Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't type whole numbers in excel they get converted to .000
I received an automatic update on Wednesday and ever since I cna not type a
whole number in a cell in Excel. The sytem automatically changes each number to a 0.0 so If I type 3 if changes to 0.3. I can't make it stop and it does it for all documents new or old. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't type whole numbers in excel they get converted to .000
You have the Fixed Decimal mode turned on. You should see 'FIX'
at the bottom right of the screen. To turn this off, go to the Tools menu, choose Options, then the Edit tab. There, uncheck "Fixed decimal". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "carrlot" wrote in message ... I received an automatic update on Wednesday and ever since I cna not type a whole number in a cell in Excel. The sytem automatically changes each number to a 0.0 so If I type 3 if changes to 0.3. I can't make it stop and it does it for all documents new or old. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
How do I stop Excel 2002 from autoformatting numbers into dates? | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions |