Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View formula results
My Excel is stuck in Formula View Mode - when I enter formula's, the cells
won't display the values just the formula. Example Formula: =D2+D3 And that's all that displays, not the value. I tried ctrl+` and that didn't work HELP - I can't calculate anything anymore! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View formula results
Try going to "Tools" then "Options" this will bring up a screen showing default settings for your Excell. Then click the "View" tab and see if "formulas" has been checked. If it has then uncheck it and your sheets should now show the values instead of the formulas. Hope it helped. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=498117 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
View formula results
"NicciS" wrote:
.. when I enter formula's, the cells won't display the values just the formula. From the above line, one other guess is that the cells may have been inadvertently pre-formatted as Text. Try selecting the entire sheet (or just the col) and re-format as say: General. Then just re-confirm the formula in the starting cell (click inside the formula bar and press ENTER) and copy down/across, etc. That should get it going. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |