Excel keeps going to 1 decimal on whole number

[ilcaa]

i type 30 excel displays 3.0, i want 30

how ca i stop this behavior, i tried formatting to number, etc, nothing works

 

[Rick Rothstein]

There is an Option setting for this, but getting to it varies between versions of Excel. The easiest way to stop it without knowing your Excel version is like this.

1) With any worksheet active, press ALT+F11 to go into the VB editor.

2) Look for the Immediate Window... if you don't see it, press CTRL+G to make it appear

3) Type this into the Immediate Window and then press the Enter Key...

Application.FixedDecimal = False

That should stop the problem you are having.

 

[ilcaa]

thanks Rick, its a 2010 version.

 

[Rick Rothstein]

thanks Rick, its a 2010 version.

I am guessing you don't want to try what I posted? Okay, here is the manual fix. Open the Excel Options (File tab, Options item), click the "Advanced" item on left, remove the check mark from the second checkbox labeled "Automatically insert a decimal point".

 

[ilcaa]

thanks Rick, that worked... now i have 2 methods to solve that problem!!