How do I Get Rid of "###" in an Excel field?

D

dblbbldick

Title tells all. This is probably so basis Old Hands will laff selves silly
but I'm roadkill alongside the on-ramp to the Infobahn. I've bludgeoned
Excel into taking new fields, but problem keeps recurring and I'd like a
permanent fix.
 
L

Luke M

Make the column wider so that the entire number can be displayed.

Have a good weekend!
 
G

Gord Dibben

Negative times or dates will show as #########

If numeric contents are too long #### will show...........widen the column.

If long strings of text, change format of cell to "General"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get Rid of the Circumflex Accent (Caret) 2
How can I get rid of completed recurring task records? 3
How can I get rid of the template task pane in Excel 3
how do I get rid of ###### that appear instead of text in excel? 2
How do I get rid of the email header in my worksheet? 2
How do I get rid of microsoft Windows validation 2
how match blanks in number field? 2
How do I get rid of Adobe Reader icon? 2

Top