Ask Experts Questions for FREE Help !
Ask
    shazydotcom's Avatar
    shazydotcom Posts: 23, Reputation: 1
    New Member
    		  
    #1

    Mar 22, 2009, 06:56 AM
    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?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 22, 2009, 03:37 PM

    Only with a previous copy.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

MS Excel spreadsheet changing numbers [ 4 Answers ]

I have a spreadsheet where I enter credit card numbers, 16 digits. One note, I have the field setup as a custom format, that displays in the custom format as ####-####-####-####. This way it automatically adds the 4 dashes. For some reason, it always changes the last digit to zero. For...

Excel: Convert numbers to date [ 4 Answers ]

I'm using excel 07 and I have a cell containing the number 11291997 which represents 11/29/1997. How can I convert this to a date format. The 11291197 is number formatted. Any suggestions would help, thanks!

Changing numbers automatically in excel [ 2 Answers ]

I have excel 2000 on my computer and downloaded a free invoice template. Over on the upper right it says invoice and then a blank for you to fill it in. I filled in a number and wanted to know if there is any way to have the invoice number change as I use the invoices without doing it manually?...

Count in excel excluding repeating numbers [ 1 Answers ]

Is there a way for me to count in a column and exclude numbers that repeat? I am working a spreadsheet with account numbers and need to count how many account numbers... the problem is that some of them repeat within the spreadsheet. Can someone help? Thanks in advance!

Padding numbers in excel [ 2 Answers ]

I have about 500,000 cells on a spreadsheet that all follow a letter and number pattern. There are two patterns that look like this: y124f07 and h67g02. So the first is: Letter, number, number, number, letter, number, number The second is: Letter, number, number, letter, number, number

View more questions Search