why do i get ###### in cells
 

i get the pound sign in some cells not what i insert, in some it shows right
in the formula bar ,some it only shows the formula

why do i get ###### in cells
 

Hi JR,

##### means that your cell is not wide enough to display the data.
Click and drag on the column border to make it show correctly.

HTH
Martin

why do i get ###### in cells
 

Column width is too narrow OR trying to work with negative dates
These are the common causes of ###########
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"j r williams" <j r wrote in message
...
i get the pound sign in some cells not what i insert, in some it shows
right
in the formula bar ,some it only shows the formula

why do i get ###### in cells
 

One other potential cause for #############

Excel has a problem with cells that contain 255 but <1024 characters.

Fornat the cell to General and your ############## should go away.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 07:10:02 -0700, j r williams <j r
wrote:

i get the pound sign in some cells not what i insert, in some it shows right
in the formula bar ,some it only shows the formula

Gord Dibben MS Excel MVP