| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm new when i input numeric data into cell & enter, goes #### and
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 -- Edge |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm new when i input numeric data into cell & enter, goes #### and
Try widening the column to see more digits.
Or use a smaller font??? I don't know about the colors. Edge wrote: 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 -- Edge -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm new when i input numeric data into cell & enter, goes #### and
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. "Edge" wrote: 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 -- Edge |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm new when i input numeric data into cell & enter, goes #### and
What is the number you are trying to input?
Apart from adjusting column widths you could try reducing the font size. "Edge" wrote: 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 -- Edge |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm new when i input numeric data into cell & enter, goes ####and
On Oct 16, 8:14*pm, Ron@Buy wrote:
What is the number you are trying to input? Apart from adjusting column widths you could try reducing the font size. "Edge" wrote: 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 -- Edge 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why input range contains non-numeric data? | Excel Discussion (Misc queries) | |||
| Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
| Excel-Input numeric value in cell, it shows up as 1/100th of entry | Excel Discussion (Misc queries) | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| how can I move cells after data input without using enter or tab | Excel Discussion (Misc queries) | |||
Linear Mode
