How do I change format
 

My Excel format seems to be messed up. If I enter an integer, for example 7,
in a cell and press enter Excel treats it as 0.07. I checked the format tab
and played with it, but cannot figure out the what the problem is. Can
someone help me with this?

Thanks,
Pradipta Sarkar

How do I change format
 

Hi Pradipta,

Tools | Options | Edit | Uncheck 'Fixed Decimal Places'


---
Regards,
Norman



"Pradipta" wrote in message
...
My Excel format seems to be messed up. If I enter an integer, for example
7,
in a cell and press enter Excel treats it as 0.07. I checked the format
tab
and played with it, but cannot figure out the what the problem is. Can
someone help me with this?

Thanks,
Pradipta Sarkar