How do I get rid of ##### in excell it will not show what I type
 

I am working in excell out of office 2003. When I try to enter a date or a
number sometimes it comes up as ##### instead of what I type. I can click on
it to read what I typed but if I want to print it ,it comes out ##### instead
of what I have typed. This is very upsetting to me because I need this info
to carry with me so I can use the info at work .I need to find out how to
stop this from happening. Thank you BUZZ

How do I get rid of ##### in excell it will not show what I type
 

Reprint of an answer by Dave Peterson

It could mean a few things.

1. The columnwidth is too narrow to show the number.


Widen the column or change the font size of that cell. Or change the
numberformat to General.


2. You have a date/time in that cell and it's negative


Don't use negative dates. If excel was helping you, it may have
changed the format to a date. Change it back to General (or some
other number format).


If you need to see negative date/times:
Tools|options|Calculation Tab|and check 1904 date system
(but this can cause trouble--watch what happens to your dates
and watch what happens when you copy|paste dates to a different
workbook that doesn't use this setting)


3. You have a lot of text in the cell, the cell is formatted as Text.


Format the cell as general.


4. You really have ###'s in that cell.


Clean up that cell.


5. You have # in a cell, but it's format is set to Fill.


Change the format
(format|cells|alignment tab|horizontal box, change it to General.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BUZZ" wrote in message
...
I am working in excell out of office 2003. When I try to enter a date or a
number sometimes it comes up as ##### instead of what I type. I can click
on
it to read what I typed but if I want to print it ,it comes out #####
instead
of what I have typed. This is very upsetting to me because I need this
info
to carry with me so I can use the info at work .I need to find out how to
stop this from happening. Thank you BUZZ

How do I get rid of ##### in excell it will not show what I type
 

Hi BUZZ,

This is the problem with column width. When a value in a cell does not fit
within the cell, it displays "#####". You can do two things.

1. Fit the contents within the column width
(to do this right click on the cell that displays ##### and goto
"Alignment" tab
and click on "Shrink to fit" or "Wrap text").
2. You can maximise the column width.
(Select all the cells in your worksheet (goto Edit menu and click on
select all cells). Goto "Format" menu and "Coloumns" then click on AutoFit.
In the similarway you do the same for "Rows".)

Now you can see all the cells displaying all values and not #####.

With kind regards.

NAVEEN.

"BUZZ" wrote:

I am working in excell out of office 2003. When I try to enter a date or a
number sometimes it comes up as ##### instead of what I type. I can click on
it to read what I typed but if I want to print it ,it comes out ##### instead
of what I have typed. This is very upsetting to me because I need this info
to carry with me so I can use the info at work .I need to find out how to
stop this from happening. Thank you BUZZ