PC Review


Reply
Thread Tools Rate Thread

Currency format for Excel 2007 not displaying actual number

 
 
gaelic_vixen
Guest
Posts: n/a
 
      13th Dec 2007
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 With Quote
 
 
 
 
ju
Guest
Posts: n/a
 
      13th Dec 2007
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Highlights & Date Format not saving/displaying correc flexnfx Microsoft Excel Misc 0 23rd Jan 2009 08:22 PM
How to format cells in Excel 2007 (i.e. currency format)? =?Utf-8?B?RG9uUg==?= Microsoft Excel Misc 2 25th May 2008 11:16 PM
Excel's financial currency format vs. Access currency format RoBo Microsoft Access Forms 0 4th Feb 2008 04:03 PM
How do I format the Currency Icon in Excel 2007? =?Utf-8?B?cmVkYW50?= Microsoft Excel Setup 0 31st Jul 2007 09:56 PM
How to translate number with currency format to pure number zlf Microsoft C# .NET 7 20th Mar 2005 04:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:45 AM.