EXCEL Formula result not displaying 1

[kajaeger]

I cannot get even a simple formula such as =SUM(30 + 60) to work in my EXCEL spreadsheet. It works fine in other spreadsheets, but when I press enter on this particular spreadsheet all I can see is my formula. I don't see the result value...advice?

 

[Hasit]

Under TOOLS-OPTIONS, in the VIEW tab, uncheck the FORMULAS check box.

 

[kajaeger]

Didn't work- it was already unchecked. I checked it and unchecked it but I still cannot get formulas to show calculation

 

[Hasit]

EH??!! Bizarre. What if yuo press F9 (calculate now) function?

 

[DaleWatson123321]

kajaeger,

I was able to produce the same end result as yours, by going into "Format Cells", choosing "Custom", and entering a "space" character under "Type".

Is it possible this might be your situation - i.e. where somehow your formatting got changed to such a "Custom" format ?

If so, you only have to change the formatting back to a regular format, or to "General".

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[kajaeger]

Thanks so Much! That was the problem!