Number Automatically divided by 100 and stored in cell

  • Thread starter Muhammad Jawad Mirza
  • 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.
 
M

Muhammad Jawad Mirza

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number automatically divided by 100, why? 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Number entries are automatically divided by 100 - Excel 2003 1
numeric entered automatically divided 100! 1
Excel automatically divides number by 100 3
numbers are being divided by 100 on leaving cell 4
Amount is divided by 100 2
Number entered in cell getting always divided by 100 ! 5

Top