Annoyign Formulae Problem

My work for the day involves calling our suppliers and getting them to
send us their price lists. I then take these price lists and format
them in a certain way and make sure the prices are right. While
formatting these documents I often run into a problem where I put a
formula into a cell, and instead of displaying the result it just
displays the formula.

Ie.

=right(A1,3) ---- displayed in a cell

Now I find I can get around this problem my selecting everything, copy
it, and paste special (values) to a new book....but this is just
annoying.

Is there a preference or setting somewhere that I can turn formulae on
or something of the sort ???

Thanks in advance !!!!!

Jonny Boy the Jester


---
Message posted from http://www.ExcelForum.com/

It's probably because the cell is formatted as text.
Format the cell as number and re-enter the formula.

-----Original Message-----
My work for the day involves calling our suppliers and
getting them to
send us their price lists. I then take these price lists
and format
them in a certain way and make sure the prices are right.
While
formatting these documents I often run into a problem
where I put a
formula into a cell, and instead of displaying the result
it just
displays the formula.

Ie.

=right(A1,3) ---- displayed in a cell

Now I find I can get around this problem my selecting
everything, copy
it, and paste special (values) to a new book....but this
is just
annoying.

Is there a preference or setting somewhere that I can
turn formulae on
or something of the sort ???

Thanks in advance !!!!!

Jonny Boy the Jester


---
Message posted from http://www.ExcelForum.com/

.

foolio

The problem most likely is caused by the fact that the cells are formatted as
Text.

Change formatting to General and re-enter your formulas.

If many formulas...........

EditReplace

What: =

With: =

Replace All.

OR hit CRTL + `(above the tab key) to toggle "View formulas" on/off

Gord Dibben Excel MVP

On Wed, 16 Jun 2004 18:10:25 -0500, foolio
wrote:

My work for the day involves calling our suppliers and getting them to
send us their price lists. I then take these price lists and format
them in a certain way and make sure the prices are right. While
formatting these documents I often run into a problem where I put a
formula into a cell, and instead of displaying the result it just
displays the formula.

Ie.

=right(A1,3) ---- displayed in a cell

Now I find I can get around this problem my selecting everything, copy
it, and paste special (values) to a new book....but this is just
annoying.

Is there a preference or setting somewhere that I can turn formulae on
or something of the sort ???

Thanks in advance !!!!!

Jonny Boy the Jester


---
Message posted from http://www.ExcelForum.com/

Hi
your cell is probably formated as 'Text'. Change this cell format to
'General' and re-enter your formula

--
Regards
Frank Kabel
Frankfurt, Germany


My work for the day involves calling our suppliers and getting them
to
send us their price lists. I then take these price lists and format
them in a certain way and make sure the prices are right. While
formatting these documents I often run into a problem where I put a
formula into a cell, and instead of displaying the result it just
displays the formula.

Ie.

=right(A1,3) ---- displayed in a cell

Now I find I can get around this problem my selecting everything,
copy
it, and paste special (values) to a new book....but this is just
annoying.

Is there a preference or setting somewhere that I can turn formulae
on
or something of the sort ???

Thanks in advance !!!!!

Jonny Boy the Jester


---
Message posted from http://www.ExcelForum.com/

yeah thats exactly right lol thanks....

okay onto another question then... this is a bad example but....

for instance in A1 have a value that you want like "Catalog# "
in A2 "1231"
in A3 "2342"
in A4 "2323"

Now in A5 i want to concat a1 and a2 .... no problem....
but when i copy the formula over to a6 to try and concat a1 and a3 it
auto changes the formula to a2 and a3...

is there a way to make a "static" cell in a formula ?


---
Message posted from http://www.ExcelForum.com/

foolio

Use $ signs as in $A$1 & A2

Drag/copy down.

See help on Absolute and Relative references for more info.

Gord Dibben Excel MVP

On Wed, 16 Jun 2004 18:35:20 -0500, foolio
wrote:

yeah thats exactly right lol thanks....

okay onto another question then... this is a bad example but....

for instance in A1 have a value that you want like "Catalog# "
in A2 "1231"
in A3 "2342"
in A4 "2323"

Now in A5 i want to concat a1 and a2 .... no problem....
but when i copy the formula over to a6 to try and concat a1 and a3 it
auto changes the formula to a2 and a3...

is there a way to make a "static" cell in a formula ?


---
Message posted from http://www.ExcelForum.com/