Formatting numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why am I getting ###### in some of the cell blocks when formatting numbers
in certain ranges?
 
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
 
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 :-)
 
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
 
You must log in or register to reply here.

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

Excel Macro to automatically go to the right of the last colored cell 0
HDMI is a terrible format and I wish it never existed 2
Excel Conditional Formatting 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Need some help with a COUNTIF function 4
Excel Conditional Formatting Removal 7
Conditional formatting 2

Back
Top