Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
BrianSteven215
 
Posts: n/a
Default A number value in Excel will on view as ####. How do I fix this?

Why is it every other cell will show the number value, but one cell will only
show ###### in the cell? How do I correct this? Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Carim
 
Posts: n/a
Default A number value in Excel will on view as ####. How do I fix this?


Is it just the column width to be increased ... ?


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531180

  #3   Report Post  
Posted to microsoft.public.excel.newusers
L Sholes
 
Posts: n/a
Default A number value in Excel will on view as ####. How do I fix this?

Yes. Either manually resize the column, or click: FormatColumnAutoFit
Selection

  #4   Report Post  
Posted to microsoft.public.excel.newusers
L Sholes
 
Posts: n/a
Default A number value in Excel will on view as ####. How do I fix this?

Yes. Either manually resize the column, or click: FormatColumnAutoFit
Selection

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
enable automatic refresh Vass Excel Worksheet Functions 2 March 11th 06 04:36 AM
My view has changed, I want same view as when opening excel migalfarucci Excel Worksheet Functions 1 October 27th 05 04:08 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Can I view an excel file without having the excel programme. boogietracy Excel Discussion (Misc queries) 1 March 31st 05 07:54 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM


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

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"