Cell returning my number divided by 100

[craftyexcel]

Hi, I'm not sure if this is an actual bug in my copy of excel. Basically I type a number into any cell and I'm returned with the number divided by 100. I've looked in cell formatting and can't see anything there. It is also across all cells in all sheets.

 

[NateO]

Does the file prompt you to enable macros?

If so, try right clicking on the sheet tab, select view code. See if there's any procedures that look like Worksheet_Change.

Could be a culprit...

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-10-15 21:17

 

[RichardS]

Check Under Tools|Options menu. On the edit Tab, is the Fixed Decimals box checked? If it is, un-check it

Richard

 

[craftyexcel]

[No message]

 

[craftyexcel]

Thanks Richard, that sorted it

 

[Mark W.]

And, BTW that's what "FIX" displayed on your Status bar indicates.