Fixed Decimal

G

Guest

In formatting cells, general automatically enters decimal places. I want to
uncheck 'fixed decimal places' but cannot find that in Excel Options. I am
using Excel 2007 and there is no Tools>Options>Edit. How can I cancel 'fixed
decimal places in Excel 2007? I don't want to enter it as text because I have
to keep going back to make this correction.
 
G

Guest

Office button, Excel options, Advanced, 2nd checkbox, which says
"Automatically insert a decimal point" (it's been renamed!)
Bob Umlas
Excel MVP
 

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

Access stripping decimal places in query 1
Round a repeating decimal from a formula... 14
adding a fixed decimal within another formula 4
problem with number format with 2 decimals? 5
need some columns to auto add decimal pt & others to not - How to. 2
Tools>options>edit>Fixed decimal places = 2 1
Formula calculating to the 3rd decimal 9
Excel Excel 2007 won't stop rounding down my formula results! 5

Top