| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting
I have a document with multiple calculations in it and for some reason today,
one of the tabs that has calculations is showing only the actual calculation and not the result. The formatting is just not working. I even have a column that is set up with a "date" format and formatting is not correct. It is showing a bunch of numbers. The other tabs with calculations in the same document are fine. Any ideas???? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting
It sounds like you may that sheet set to display only formulas....
Try this: Hold down [Ctrl] and press the [~] key (in the upper left of the keyboard) That will toggle Formula Display On/Off Does that help? *********** Regards, Ron XL2002, WinXP "Amber" wrote: I have a document with multiple calculations in it and for some reason today, one of the tabs that has calculations is showing only the actual calculation and not the result. The formatting is just not working. I even have a column that is set up with a "date" format and formatting is not correct. It is showing a bunch of numbers. The other tabs with calculations in the same document are fine. Any ideas???? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting
Check the format of the data: it suggests they are TEXT rather than the
required format. "Amber" wrote: I have a document with multiple calculations in it and for some reason today, one of the tabs that has calculations is showing only the actual calculation and not the result. The formatting is just not working. I even have a column that is set up with a "date" format and formatting is not correct. It is showing a bunch of numbers. The other tabs with calculations in the same document are fine. Any ideas???? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting
That worked wonderfully. Thanks you so much. I was getting a little
frustrated. :) "Ron Coderre" wrote: It sounds like you may that sheet set to display only formulas.... Try this: Hold down [Ctrl] and press the [~] key (in the upper left of the keyboard) That will toggle Formula Display On/Off Does that help? *********** Regards, Ron XL2002, WinXP "Amber" wrote: I have a document with multiple calculations in it and for some reason today, one of the tabs that has calculations is showing only the actual calculation and not the result. The formatting is just not working. I even have a column that is set up with a "date" format and formatting is not correct. It is showing a bunch of numbers. The other tabs with calculations in the same document are fine. Any ideas???? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
Linear Mode
