I'm new when i input numeric data into cell & enter, goes #### and

  • Thread starter Thread starter Edge
  • Start date Start date
E

Edge

can't see zeros but I am in general tab and i'm trying to put together an
account statement but when i input the invoice number and press enter, the
cell goes ############# - i can't find where to change the formatting and
sorry - silly questions to you guys but i've never worked with excel - also,
is there a way to change colours of office 2007 apart from silver and black
as i'm pretty attached to my 2003 colours
thanks
 
Try widening the column to see more digits.

Or use a smaller font???

I don't know about the colors.
 
The column may be to narrow. At the top of your spread sheet are the column
letters - A B C D E... The is a verticle line seperating each letter.
For the column displaying the ##### double click on the line seperating your
column identifier and the next one to the right. That will automatically
resize your column to fit.

There is an Excel option to show zero values in fields but someone else will
ahve to tell you about that.
 
What is the number you are trying to input?
Apart from adjusting column widths you could try reducing the font size.
 
What is the number you are trying to input?
Apart from adjusting column widths you could try reducing the font size.



Edge said:
can't see zeros but I am in general tab and i'm trying to put together an
account statement but when i input the invoice number and press enter, the
cell goes ############# - i can't find where to change the formatting and
sorry - silly questions to you guys but i've never worked with excel - also,
is there a way to change colours of office 2007 apart from silver and black
as i'm pretty attached to my 2003 colours
thanks
Click to expand...
Click to expand...

COLORS: Only blue, silver and black are available.
Excel
Click the Microsoft Office Button (upper left corner), and then click
Excel Options at the bottom of the window.
Click Popular, and then click the Color scheme that you want.
 
Back
Top