Why do these symbols #### appear after correcting data in a cell?

[Guest]

After correcting or updating informartion entered into a cell, then going to
next cell, all of these appear in the previous cell instead of the
information entered & saved?

 

[Otto Moehrbach]

Jim
That usually happens when the column is not wide enough to hold the
information in that cell. You will get this when the cell content is a
number. Post back if you need more. HTH Otto

 

[David Biddulph]

A number of possibilities.
The most likely is that the column width is insufficient for displaying your
data. You can either widen the column (for example by autofit), or reduce
the font size.
Another posibility is that you are trying to display a negative number in
date or time format. In that case, switch to 1904 date format but be aware
of the dangers.

 

[Dave Peterson]

I bet #3 for you.


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.

 

[Guest]

Thank you

Jim
That usually happens when the column is not wide enough to hold the
information in that cell. You will get this when the cell content is a
number. Post back if you need more. HTH Otto

 

[Guest]

Thanks

A number of possibilities.
The most likely is that the column width is insufficient for displaying your
data. You can either widen the column (for example by autofit), or reduce
the font size.
Another posibility is that you are trying to display a negative number in
date or time format. In that case, switch to 1904 date format but be aware
of the dangers.

 

[Guest]

Thank you very much, Mr. Peterson

I bet #3 for you.


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.