Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SWAN_943
 
Posts: n/a
Default Failure to display currency format

My document is almost complete, except that two cells are only displaying
'######' when in currency format or while holding 2 decimal places. I just
can't figure it out!
--
ANY HELP IS GREATLY APPRECIATED
  #2   Report Post  
Tim Childs
 
Posts: n/a
Default

have you tried increasing the column width?
Tim


"SWAN_943" wrote in message
...
My document is almost complete, except that two cells are only displaying
'######' when in currency format or while holding 2 decimal places. I

just
can't figure it out!
--
ANY HELP IS GREATLY APPRECIATED



  #3   Report Post  
Cutter
 
Posts: n/a
Default


OR

Decrease the size of the font in those 2 cells


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=472394

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate and display ratio ( format 3.5:2) BKW Excel Worksheet Functions 4 September 28th 05 07:38 PM
How do I format currency field in Excel 2000 w/o 2 extra zeroes? slmm Excel Discussion (Misc queries) 2 July 12th 05 03:06 PM
convert a numerical currency into word format Rojo Excel Worksheet Functions 1 February 24th 05 11:31 PM
How do I format the date in a footer to display the month in lett. RBono Excel Discussion (Misc queries) 1 February 10th 05 01:59 AM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"