Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.9 Any number I type in gets divided by a power of 10. Why? (spreadsheets: Excel)

Excel has an option `Fixed Decimal Places', which divides all
constants entered directly in the cell by a power of 10 (e.g.,
entering 622 would change to 6.22).

change the setting to `0' via:

Tools|Options|Edit|Fixed Decimal Places

10.10 Excel complains about TIMER.DRV on startup. What can I do?

see http://support.microsoft.com/support/kb/articles/q109/7/78.asp
see ftp://ftp.microsoft.com/deskapps/excel/kb/q109/7/

 

Continue to:

• prev: 10.8 When I start up Excel, it tries to open a lot of files; some of them are non-Excel files...
• Index
• next: 10.11 I get odd (square?) characters where I expect commas (thousands) or slashes (dates). What happened? (spreadsheets: Excel)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro