Works perfect with me. This is how I do it.
1. I type the phonenumber as text by starting with a quote: '001234567891
2. I export to csv-format
3. I open the csv-file with Notepad and look at the result. It's 001234567891
What I don't do: open the csv-file with Excel. That's because I know Excel displays such long numbers in the scientific format. I don't care about how Excel shows it. I just look in the file with Notepad to see what's really in it and I am happy with the result.
But I don't know, of course, how your phone imports this perfect csv-file. It might be necessary to add quotes around the number in the csv-file: "001234567891" to tell the phone it's text, not a number.
*how can i stop phone nubmers being converted into rubbish when going form Excel to CSV?
I have just tidied up my bloated contact list in excel.
i want to upload to google contacts / outlook as a .CSV file.
when i do so, the phone numbers shift into a different format. example a british mobile number like
0044 77190 19091 is switched into 4.47719E+11,
which my phone can not then read when uploaded.
I HAVE TRIED SO FAR...
...pressing ctrl+1 and selecting format as text
...opening the excel file and 'save as' to a comma delimited file
...concatenating to add spaces in front and at the end of the numbers in excel, so that the CSV file might see them as text
...saving the numbers only into a new .txt file, then going into the .CSV file and using the data > 'get external data' > import from text.
RESULT SO FAR
in all instances i can get the numbers in the right format in the CSV file, but when i come to save, i get a message saying that some of my preferences might not be saved. when i reopen the CSV file, the numbers are back in the dud format.
would be very grateful to any experts who can help. it is driving me nuts.
Running Windows 7, Ofice/Excel 2010