Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
###### 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
###### 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
###### 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
###### 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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
###### 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
x and y axis, enter x value, enter y value, value at intersect.... | Excel Worksheet Functions | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) |