| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to stop automatic division of numbers in Excel
Hi,
For some reason whenever I enter numbers into Excel 2003 now without the = sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1 becomes .0001). I don't know what I did to start this problem but I can't figure out how to solve it. Thanks for any help, Justin |
|
#2
|
|||
|
|||
|
Hi!
Goto ToolsOptionsEdit And see if you have Fixed Decimal Places set to 4. Biff -----Original Message----- Hi, For some reason whenever I enter numbers into Excel 2003 now without the = sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1 becomes .0001). I don't know what I did to start this problem but I can't figure out how to solve it. Thanks for any help, Justin . |
|
#3
|
|||
|
|||
|
Justin
ToolsOptionsEdit. Uncheck "fixed decimal places" Gord Dibben Excel MVP On Sat, 19 Feb 2005 22:37:03 -0800, Justin wrote: Hi, For some reason whenever I enter numbers into Excel 2003 now without the = sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1 becomes .0001). I don't know what I did to start this problem but I can't figure out how to solve it. Thanks for any help, Justin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
| BRACKETED NEGATIVE NUMBERS IN EXCEL | New Users to Excel | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| In Excel, how to sum top 10 greatest values in a row of numbers? | Excel Worksheet Functions | |||
| How do I stop the autopaste function in Excel? | Excel Worksheet Functions | |||
Linear Mode
