If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
###### when trying to enter a $ fugure
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 |
#2
|
|||
|
|||
###### when trying to enter a $ fugure
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 |
#3
|
|||
|
|||
###### 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 |
#4
|
|||
|
|||
###### when trying to enter a $ fugure
Got it now, i dont know what i was doing but i just cleared that column and
started again and all was ok...Thanks for your help.... "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 |
#5
|
|||
|
|||
###### when trying to enter a $ fugure
That is the message Excel gives when there is not enough room to display the
whole contents, most often seen with dates. Just make your column a little wider. -- Best Regards, Luke Moraga "Justina" wrote: Got it now, i dont know what i was doing but i just cleared that column and started again and all was ok...Thanks for your help.... "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 |
Thread Tools | |
Display Modes | |
|
|