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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel converted numbers to dates suddenly in All Sheets!!!! 3
how do i make #'s auto and 000 behind large numbers 4
Formula to identify decimal versus whole numbers 12
Decimal Numbers typed into Excel 2003 read as whole numbers 1
when I type numbers in a cell it changes it to a decimal point 4
How do I get numbers converted to cost? 1
rounding up to nearest specified whole number 1
Whole Numbers in Excel with Mail Merge 2

Top