A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

###### when trying to enter a $ fugure



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2007, 02:42 PM posted to microsoft.public.excel.newusers
Justina
external usenet poster
 
Posts: 20
Default ###### 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  
Old April 20th, 2007, 02:58 PM posted to microsoft.public.excel.newusers
William Horton
external usenet poster
 
Posts: 76
Default ###### 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  
Old April 20th, 2007, 03:08 PM posted to microsoft.public.excel.newusers
Justina
external usenet poster
 
Posts: 20
Default ###### 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  
Old April 20th, 2007, 03:16 PM posted to microsoft.public.excel.newusers
Justina
external usenet poster
 
Posts: 20
Default ###### 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  
Old April 23rd, 2007, 09:04 PM posted to microsoft.public.excel.newusers
Luke Moraga
external usenet poster
 
Posts: 9
Default ###### 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.