Function Formula is displayed not results

[Kevin Gillilland]

I can't get the cell to display the results of a formula. Only the formula
is displayed. Under options, view, the formula box is not checked. I'm
using concatentate and the fields are formated as text

 

[Jason Morin]

You want the cells formatted as General, not Text. Save
the formula somewhere, delete the current contents of the
cells, reformat as General, then re-insert the formulas.

HTH
Jason
Atlanta, GA

 

[David McRitchie]

Hi Kevin,
If F2 then enter fixes it or if F9 fixes it then you have calculation turned off.

Make sure you have calculation turned on
Tools, Options, Calculation (tab), Calculation: automatic
shortcut toggle is Alt+` (accent grave) or whatever is to left of the number row.

If that is not the problem then you probably have a space or other character
in the formula where it doesn't belong like before the equal sign.

If you don't see the problem/solution yet then try TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
you might have CHAR(160) the nonbreaking space character (&nbsp
which you are likely to have if you copy your data from HTML.

Keyboard shortcuts in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

 

[David McRitchie]

Another way of accomplishing what Jason suggested is to
format the column first as General, then when the column(s)
still select use replace (Ctrl+H) to replace "=" by "="
(without the quotes).

 

[iloveexcellllll]

Also, just be sure you have typed and equal sign at the beginning of your
formula.

Hi Kevin,
If F2 then enter fixes it or if F9 fixes it then you have calculation turned off.

Make sure you have calculation turned on
Tools, Options, Calculation (tab), Calculation: automatic
shortcut toggle is Alt+` (accent grave) or whatever is to left of the number row.

If that is not the problem then you probably have a space or other character
in the formula where it doesn't belong like before the equal sign.

If you don't see the problem/solution yet then try TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
you might have CHAR(160) the nonbreaking space character ( )
which you are likely to have if you copy your data from HTML.

Keyboard shortcuts in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I can't get the cell to display the results of a formula. Only the formula
is displayed. Under options, view, the formula box is not checked. I'm
using concatentate and the fields are formated as text