EXCEL OPERATION

[john fleming]

WHEN INSERTING NUMBERS INTO CELLS THE RESULT WILL BE
DIVIDED BY 100 UNLESS I TYPE IN A DECIMAL POINT AFTER THE
NUMBER.
IF THE NUMBER CONTAINS DECIMAL POINT IT ENTERS OK

 

[Gord Dibben]

John

Tools>Options>Edit. Un-check "fixed decimal places"

Gord Dibben Excel MVP XL2002