T
tls
How do I get rid of ########## in text boxes in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gordon
tls said:How do I get rid of ########## in text boxes in Excel?
Depends what's caused it!
D
DNA
It sounds like the cell is not large enough to display the data; stretch
the cell wider and see what happens.
HTH
the cell wider and see what happens.
HTH
D
Dave Peterson
Did you really mean textboxes or cells on a worksheet?
If you meant cells in a worksheet...
It could mean a few things.
1. The columnwidth is too narrow to show the number.
2. You have a date/time in that cell and it's negative
3. You have a lot of text in the cell, the cell is formatted as Text.
4. You really have ###'s in that cell.
5. You have # in a cell, but it's format is set to Fill.
To fix #1: Widen the column or change the font size of that cell
To fix #2: 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)
To fix #3: Format the cell as general.
To fix #4: Clean up that cell.
To fix #5: Change the format
(format|cells|alignment tab|horizontal box, change it to General.
If you meant cells in a worksheet...
It could mean a few things.
1. The columnwidth is too narrow to show the number.
2. You have a date/time in that cell and it's negative
3. You have a lot of text in the cell, the cell is formatted as Text.
4. You really have ###'s in that cell.
5. You have # in a cell, but it's format is set to Fill.
To fix #1: Widen the column or change the font size of that cell
To fix #2: 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)
To fix #3: Format the cell as general.
To fix #4: Clean up that cell.
To fix #5: Change the format
(format|cells|alignment tab|horizontal box, change it to General.
D
Dave Peterson
ps. If you really meant a textbox, is it on a worksheet or a real userform
(created in the VBE)?
If it's on a worksheet, is it from the Drawing toolbar or from the Control
toolbox toolbar?
(created in the VBE)?
If it's on a worksheet, is it from the Drawing toolbar or from the Control
toolbox toolbar?