A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A number value in Excel will on view as ####. How do I fix this?



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2006, 02:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
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  
Old April 8th, 2006, 03:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
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  
Old April 8th, 2006, 06:31 PM posted to microsoft.public.excel.newusers
external usenet poster
 
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  
Old April 8th, 2006, 06:32 PM posted to microsoft.public.excel.newusers
external usenet poster
 
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

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Worksheet Functions 23 January 30th, 2006 06:16 PM
Report with set number of rows per page Ken from Chicago Running & Setting Up Queries 7 January 4th, 2006 02:42 PM
Report with set number of rows per page Ken from Chicago Setting Up & Running Reports 7 January 4th, 2006 02:42 PM
Combo Box (1st) Populating Text Box (2nd) Field AccessRookie Using Forms 1 April 6th, 2005 11:37 PM
How do I set-up automatic number generation in Excel? General Discussion 0 November 16th, 2004 04:58 PM


All times are GMT +1. The time now is 06:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.