I can't type whole numbers in excel they get converted to .000

C

carrlot

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.
 
C

Chip Pearson

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
 
Top