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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - When using Excel 2007 when I enter a 1, I get this 0.01. What do . (https://www.excelbanter.com/excel-discussion-misc-queries/143376-when-using-excel-2007-when-i-enter-1-i-get-0-01-what-do.html)

digger

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

Gord Dibben

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

With earlier versions you go into ToolsOptionsEdit and uncheck "fixed decimal
places"

2007 version should be similar.

Gord Dibben MS Excel MVP

On Sat, 19 May 2007 10:13:21 -0700, digger
wrote:

Teethless mama

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

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

"Gord Dibben" wrote:

With earlier versions you go into ToolsOptionsEdit and uncheck "fixed decimal
places"

2007 version should be similar.

Gord Dibben MS Excel MVP

On Sat, 19 May 2007 10:13:21 -0700, digger
wrote:

All times are GMT +1. The time now is 06:07 AM.