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.