Annoyign Formulae Problem

F

foolio

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

Ie.

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

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

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

Thanks in advance !!!!!

Jonny Boy the Jeste
 
G

Guest

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

Gord Dibben

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...........

Edit>Replace

What: =

With: =

Replace All.

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

Gord Dibben Excel MVP
 
F

Frank Kabel

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

foolio

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 i
auto changes the formula to a2 and a3...

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

Gord Dibben

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
 
Top