LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why input range contains non-numeric data? Nickman Excel Discussion (Misc queries) 10 April 3rd 23 06:49 PM
Vlookup if #N/A then enter enter data in cell I4 duketter Excel Discussion (Misc queries) 3 March 11th 08 09:08 PM
Excel-Input numeric value in cell, it shows up as 1/100th of entry DarinMelin Excel Discussion (Misc queries) 2 October 31st 07 06:14 PM
Auto enter date when data in enter in another cell Brian Excel Worksheet Functions 5 December 7th 06 06:44 PM
how can I move cells after data input without using enter or tab mull Excel Discussion (Misc queries) 1 March 2nd 05 05:53 PM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"