microsoft office 2010 excel rounds 2 decimals by default

September 17, 2012 at 07:14:04
Specs: Windows 7
i am using microsoft office 2010 and excel automatically rounds off 2 decimals to a whole number in some columns of some rows of some worksheets; any ideas how to turn this off?
Thanks.

See More: microsoft office 2010 excel rounds 2 decimals by default

Report •


#1
September 17, 2012 at 07:27:13
Check your Editing Option:

For 2007:

Click the Microsoft Office button
Click on the Excel / Word Options button to bring up the Options dialog box (at the bottom of window)
Click Advanced button in the left hand pane

Under Editing Options,
make sure you have the "Automatically Insert a Decimal Point"
box UN-checked.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question