Formatting numbers

T

tehya

Why am I getting ###### in some of the cell blocks when formatting numbers
in certain ranges?
 
G

Gord Dibben

The # signs when data is numeric indicates the column is not wide enough.

Drag the column border to widen it.

There are other scenarios that could cause the # signs, but you did state
"numbers"


Gord Dibben MS Excel MVP
 
K

Ken Wright

Or ( For the OPs benefit, not Gord's :-> ) just double click the column
border and it will automatically resize itself to the widest point necessary
to display all data within the column correctly :)
 
G

Gord Dibben

You're too kind Ken

I forget alla time about the double-click so neglect to add to postings.


Gord

Or ( For the OPs benefit, not Gord's :-> ) just double click the column
border and it will automatically resize itself to the widest point necessary
to display all data within the column correctly :)
Click to expand...

Gord Dibben MS Excel MVP
 
Top