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

widen the column

--
Don Guillett
SalesAid Software

"tehya" wrote in message
...
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

On Tue, 4 Jul 2006 14:28:01 -0700, tehya
wrote:

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

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 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Gord Dibben" wrote:

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

On Tue, 4 Jul 2006 14:28:01 -0700, tehya
wrote:

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

You're too kind Ken

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


Gord

On Wed, 5 Jul 2006 02:35:02 -0700, Ken Wright
wrote:

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 :-)

Gord Dibben MS Excel MVP

Have you noticed that Gord is starting to mellow?

--
Don Guillett
SalesAid Software

"Ken Wright" wrote in message
...
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 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Gord Dibben" wrote:

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

On Tue, 4 Jul 2006 14:28:01 -0700, tehya

wrote:

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