Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel changed numbers to zeros (https://www.askmehelpdesk.com/showthread.php?t=332327)

  • Mar 22, 2009, 06:56 AM
    shazydotcom
    Excel changed numbers to zeros
    Dear All,

    I exported my cell phone contacts to my PC, which created an excel file for the contacts. It was as names and numbers in different columns. Now when I have opened the file after some time, I see that the long numbers have been changed to 9.67E+11. I increased the column width but did not work. Moreover when I bring the cursor to the cell in the formula bar it shows the number as 966568000000 which means that Excel has removed the original last six digits and changed them into zeros. Now what is the reason and is there any way that I can get back the numbers?
  • Mar 22, 2009, 03:37 PM
    JBeaucaire

    Only with a previous copy.

  • All times are GMT -7. The time now is 08:27 AM.