Number Automatically divided by 100 and stored in cell

  • Thread starter Thread starter Muhammad Jawad Mirza
  • Start date Start date
M

Muhammad Jawad Mirza

Dear Friends,
I am facing a problem. When I type say 1000 in an excel
cell it apperas as 10 in that cell and in Formulabar ( the
original value 1000 lost). Similarly 12345 appears as
123.45. I have checked the number formatting which is
General. In each case after pressing Enter key the number
is first divided by 100 and then result is stored in the
cell. I could not find the reason why it is happening so.
Please guide me in this regard. I will be very thankfull
for your help.
 
Dear Andy B.,

Thanks a lot. It's working well. Thanks one again. May God
bless you. Thanks also for Microsoft for such a good
problem solving platform.

Muhammad Jawad Mirza
 
Back
Top