Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency format for Excel 2007 not displaying actual number
For some reason, the cell that contains the sum total for about 38 pages of
grant sums doesn't show the actual number, but instead displays as a series of #'s. Every other cell in that column is formatted exactly the same way as that one, but the total is the only one that doesn't display the number itself. I can't for the life of me figure out wth the problem is. Any ideas? Thanx in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency format for Excel 2007 not displaying actual number
you got to increase the column width
gaelic_vixen wrote: For some reason, the cell that contains the sum total for about 38 pages of grant sums doesn't show the actual number, but instead displays as a series of #'s. Every other cell in that column is formatted exactly the same way as that one, but the total is the only one that doesn't display the number itself. I can't for the life of me figure out wth the problem is. Any ideas? Thanx in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot table cells number format changes w/out user inpu | Excel Discussion (Misc queries) | |||
How do I format the Currency Icon in Excel 2007? | Setting up and Configuration of Excel | |||
How do I format to currency when number includes cents? | Excel Worksheet Functions | |||
why does currency format change to number format? | Excel Discussion (Misc queries) |