When using Excel 2007 when I enter a 1, I get this 0.01. What do .

G

Gord Dibben

With earlier versions you go into Tools>Options>Edit and uncheck "fixed decimal
places"

2007 version should be similar.


Gord Dibben MS Excel MVP
 
T

Teethless mama

Click on Office Button > Excel Options > Advanced tab > Uncheck Automatically
insert a decimal point
 

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

When I type in a 1 it puts up .0001 how do I change this? 1
integers entered are converted into decimal places e.g. 1 = 0.01 1
Automatically changing my numerical entry- when I don't want it to 2
How do I have the first few rows not be numbered? 1
How do I increase the number of columns in excel above 256 0
Always enter number as a decimal <1 11
How do I link info from a key sheet to drop down lists in Excel? 0
In Vista, how do I stop the cursor moving after each entry? 1

Top