Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Loosing phone number format when saving xls to csv format

Nov 13, 2014 7:51PM PST

Hi guys,

i know this is a repeat...but I am stuck with this.

i have an xls with some phone numbers of 12 digit ( eg: 902123456789). when i save it as csv it turns into scientific format(9.02166E+11 ). i tried out options listed in this forum like prepending it with " ' " and opening it in wordpad, changing format to text etc. when i open this csv in wordpad i am able to see the correct number ie in correct format. but my issue is i need to upload this csv file into a tool and when i do this i get a prompt from tool that invalid format of phone number.

i think what is happening is that the number is in correct format (in formula bar) when since its format is scientific in the cells i am getting error. any suggestions to solve this will be really appreciated.

TIA

Discussion is locked

- Collapse -
Why not change the format of the cell?
Nov 13, 2014 10:40PM PST
- Collapse -
Duplicate post.
Nov 13, 2014 10:48PM PST