A weird problem has hit the excel installation on my system (very likely, I changed one of the settings unintentionally .... don't think so, but could this be some virus too ?). Here's the issue:In any open excel file, when I type in, say 8000 and press enter, excel converts the 8000 to the value 8. The 8 is displayed, as well as the same value shows in the formula bar. On typing : =8000, this problem is not there i.e. I get 8000 for typing in =8000Excel is somehow dividing all numbers which I enter, by 1000 (i.e. enter 6123, it converts it into 6.123 and that's what I get). It something similar to, when we have a cell formatted to a "Percentage" formatting then entering 25, gives your 25% (which is 0.25). But in my excel, I see the cell formats to be ok (by default, it's General). Even on changing the format to "Number" and retyping, that problem still stays.Could any excel expert please help. edit: One more thing, on typing 3.172, division by 1000 does not happen -> it remains 3.172

What version? Never used 2007, but if you have 2003 or earlier, go to Options > Edit tab > Uncheck the Fixed Decimal option.

Works great ... thanks for your help.(I too have Excel 2003)

I think what you have is an issue with your default template

Well .... this is how our IT guys fixed the problem (this was before MMP posted the Fixed Decimal option solution) : They removed ... i mean, just renamed the entry for HKEY_CURRENT_USER->...->office->excel in the windows registry to a dummy value).Restarting excel, caused the office installer to re-run and a new registry entry for excel was created. This one had all the default settings (including the default setting for Fixed Decimal option).So, the problem got fixed .... though neither the IT nor me came to know what the cause was.I have got the record of that old "dummy value" excel registry entry and could re-activate the problem by naming it back to "excel". I am nearly sure, when I revert to the old registry entry and apply MMP's solution, things will be ok. (... Too lazy to do that, though!).However, I can re-create the problem in my new excel setup by doing the reverse of what MMP has advised. Hence, I don't think this was an issue with the default template or anything else.-------------------------------------------Finding a solution to this kind of problem on internet was hard ... I went googling for phrases like "automatically divide by 1000 in excel" etc. (Last night, when I fooling around with my excel ..... actually trying to help with another guy's excel problems, I guess, I unintentionally checked the Fixed Decimal option)