| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I Get Rid of "###" in an Excel field?
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I Get Rid of "###" in an Excel field?
Make the column wider so that the entire number can be displayed.
Have a good weekend! -- Best Regards, Luke M "dblbbldick" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I Get Rid of "###" in an Excel field?
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 On Fri, 30 Apr 2010 09:58:02 -0700, dblbbldick wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
Hybrid Mode
