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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
####
What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included. |
#2
|
|||
|
|||
####
See the HELP section for a good explanation of the ####. It could be that
your column is just not wide enough to display the entry. If you are trying to add LEADING zeros to a string, type an apostrophe first. It will not show up on the cell, only in the formula bar, and changes the cell format to TEXT. Or, you can just format the cell for TEXT before inserting the leading zeros. Vaya con Dios, Chuck, CABGx3 "Teri" wrote: What does it mean when these ##### come up? how do I fix it? Also, how do I add ZERO's? When I add a ZERO, it is not included. |
#3
|
|||
|
|||
####
A cell with ##### generally indicates the column is not wide enough to
display the value stored: make the column wider by pulling the bar between the column headers (to make column B wider, pull the bar between B and C) 0r use Format Column and change the width. A negative date value can also cause cell to show ### If you want to see 0123 and not 123: type a single quote (') then the digits OR format the cell with Custom Format 0000. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Teri" wrote in message ... What does it mean when these ##### come up? how do I fix it? Also, how do I add ZERO's? When I add a ZERO, it is not included. |
#4
|
|||
|
|||
####
one guess on your 2nd question
..Also, how do I add ZERO's? When I add a ZERO, it is not included. Type a preceding apostrophe if you want leading zeros eg: enter it as '090 The apostrophe won't display in the cell, but it'll become a text number -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
|
|||
|
|||
####
One more suggestion for the #### could be negative date or time.
And another. If you have between 255 and 1024 characters in the cell and are formatted to Text, you will get the #####. If that is the case, format to General. Gord Dibben MS Excel MVP On Wed, 16 Jan 2008 07:14:01 -0800, Teri wrote: What does it mean when these ##### come up? how do I fix it? Also, how do I add ZERO's? When I add a ZERO, it is not included. |
Thread Tools | |
Display Modes | |
|
|