MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Number input problem


Posted by Gary Baxter on September 21, 2000 12:31 PM

Excel 2000 - When I input number, e.g. 13, it is entered as 1.3. If I use =13, then it enters correctly as 13. How do I fix this?


Posted by Celia on September 21, 2000 5:05 PM

Gary
Go to Tools>Options>Edit and un-check Fixed Decimal Places (or re-set it to what you want).
Celia

Posted by Gary Baxter on September 22, 2000 10:56 AM

Celia
Thank you very much!
Gary


Posted by Gary on September 22, 2000 10:58 AM

Celia
Thank you very much!
Gary