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

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

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

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