###### when trying to enter a $ fugure
Thanks William...Whats happening is when i enter the figure it is as it
should be until i press enter and then it turns to ####### but as i say
closer together..It doesnt matter what i do i cant seem to shake it, i know i
must be doing something wrong but i just cant figure it out. I am a new user
so that doesnt help, i am using 2000, can you think of anything else it may
be???
"William Horton" wrote:
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
|