Are you sure the cell is formatted as General (or some other number format)
and not Date. The Date format makes #### a lot.

If that doesn't work try using the format painter to copy the format from a
column that is working to the column that isn't working. You may have to
re-enter the values after you change the format however.

Hope that helps.

"Justina" wrote:

I am getting ##### but closer together in my worksheet when trying to enter a
sales figure, i have chkd the format cells option with no joy, the rest of
the worksheet is behaving except this column, Doh!! any suggestions??? Please