Hi All,

Ihave a problem sum XL hotshot can help me.
Eg. When I type a number into a cell it div. it by 100 --- 3 displays .003, 156 displays 1.56 . This on all my files old and new. Nothing in Tools/Options/Calculations.
Be pleased for any help as hard to do rating without spreadsheet.
Rgds Ray.