Numbers changed into zeros
Hi
The original number was not lost.
Try
Select all the cells in this format
Right click
Select Format Cells
Choose Number in Category under Number tab
Change decimal place to 0
click OK
I believe it is Excel's way of shortening a long number, given that
4.48*100000000000 will give you 448000000000
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"shazydotcom" wrote:
Dear Jackob,
I tried to do so but it returns the value as in the formula bar. In other
words 44800000000. It shows that the original numbers have been lost. The
question is why they were lost and how to recover them?
"Jacob Skaria" wrote:
Select all Ctrl+A
Rightclick Format Cells
Select Number with number of decimals 0
If this post helps click Yes
--------------
Jacob Skaria
"shazydotcom" wrote:
I have a problem that i had phone numbers in excel columns. After some time I
have opened the file and see that Excel has changed the phone numbers into
the format like 4.48E+11 and in the formula bar it shows like 448000000000.
It means that Excel has replaced the last 9 digits with zeros. This has
happened to majority of cells within one worksheet while yet there are
certain cells which were not affected by this problem and they are showing
the original numbers correctly. Please help me how can i recover my original
numbers and why this problem has happened.
|