Excel is changing the numbers typed in.

[Darren Bartrup]

Got a weird one here.

My colleague is having trouble with Excel 2003 (not workbook specific).
When he types in a number it assumes the last two digits are after the decimal place

1000 will change to 10
13 will change to 0.13

This isn't a formatting problem - the number is changed in the formula bar and in calculations based on that number.

If I type 13 (which gets changed to 0.13) then =ROUND(A1,0) it displays 0.

We've commented out all his VBA code in the Personal workbook and it still doing it.

980 with the cell formatted to numbers with 0 decimal places will show 10 (9.80 rounded).

We've both got 2003 & 2007 installed, but it's only him that has that problem in 2003.

Any ideas?

 

[Jonmo1]

In XL2003..

Tools - Options - Edit
UNcheck "Fixed Decimal Places"


Hope that helps.

 

[Darren Bartrup]

Thank you!

Shhh.... don't tell anyone I asked though.