Data Entry Problem

[rqueneau]

Very strange behavior just started. Even on a new spreadsheet, if I enter a
number in a cell, like the number 5, it's instantly diveied by 100 and the
cell contains 0.05. I work with a lot of engineering spreadsheets and they
all started doing this. I've tried formatting the cells to General, Number
(with no decimal places) and others, but it continues to happen. Ran Office
diagnostics but it came up with nothing. The problem is local to my laptop
only. I emailed a problem spreadsheet to my home system and tried it there.
Everything works fine. I enter 2, and the cell shows 2.

Has anyone seen this before and if so, what is the fix? Please help as this
is making my life miserable. Thanks.

 

[FSt1]

hi
you have fixed decimais in place.
2003-on the menu bar.....
tool>options>edit tab> uncheck fixed decimal places
2007
office button>excel options>not sure after this.
2007 expert - help

Regards
FSt1

 

[Sheeloo]

Excel 2007
office button>excel options>advanced
clear the check box 'Automatically insert a decimal point'

 

[FSt1]

thanks
regards
FSt1

Excel 2007
office button>excel options>advanced
clear the check box 'Automatically insert a decimal point'