Data Entry Problem
 

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.

Data Entry Problem
 

hi
you have fixed decimais in place.
2003-on the menu bar.....
tooloptionsedit tab uncheck fixed decimal places
2007
office buttonexcel optionsnot sure after this.
2007 expert - help

Regards
FSt1

"rqueneau" wrote:

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.

Data Entry Problem
 

Excel 2007
office buttonexcel optionsadvanced
clear the check box 'Automatically insert a decimal point'

"FSt1" wrote:

hi
you have fixed decimais in place.
2003-on the menu bar.....
tooloptionsedit tab uncheck fixed decimal places
2007
office buttonexcel optionsnot sure after this.
2007 expert - help

Regards
FSt1

"rqueneau" wrote:

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.

Data Entry Problem
 

thanks
regards
FSt1

"Sheeloo" wrote:

Excel 2007
office buttonexcel optionsadvanced
clear the check box 'Automatically insert a decimal point'

"FSt1" wrote:

hi
you have fixed decimais in place.
2003-on the menu bar.....
tooloptionsedit tab uncheck fixed decimal places
2007
office buttonexcel optionsnot sure after this.
2007 expert - help

Regards
FSt1

"rqueneau" wrote:

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.