How to save a csv file without scientific notation

[Kelli Webb]

Hi,

I'm trying to save a list of mobile numbers, including the international code as a csv file so I can load it into a third party group message service.

It all works fine until I get to a few NZ numbers (Note: their numbers can vary in length) and no matter what I do, it converts it to a scientific notation.

I've wasted a lot of the day going back over this as time permits, and I'm no closer to finding a resolve.

If anyone can shine some light on this, that would be fantastic.

I hope you're all well & staying safe!!
thanks, Kelli

 

[GraH - Guido]

Hi Kelli,
Not clear if you are loading csv to Excel (and having the issue) or saving Excel as .csv (and having the issue)?

EDIT: if you have the data clear in Excel copy that column in a notepad or notepad(++). Save as the notepad as .csv.

 

[Marc L]

Hi,​

​

format the column as text before …​

​

 

[Kelli Webb]

Hi Kelli,
Not clear if you are loading csv to Excel (and having the issue) or saving Excel as .csv (and having the issue)?

EDIT: if you have the data clear in Excel copy that column in a notepad or notepad(++). Save as the notepad as .csv.

Hi Guido,
I need to save it as a csv file that will be uploaded to a third party messaging service.

If I save it as a notepad, I would have to format it to include comma's to separate each column.

This has been an issue in excel from the onset

thanks anyway. Take care!!

 

[GraH - Guido]

If I save it as a notepad, I would have to format it to include comma's to separate each column.

Not really, as you can use textjoin or concatenate.

Formula here =""""&TEXTJOIN(""",""",FALSE,A2:C2)&""""



EDIT: concatenate version: =""""&A2&""","""&B2&""","""&C2&""""

 

[Kelli Webb]

Not really, as you can use textjoin or concatenate.

Formula here =""""&TEXTJOIN(""",""",FALSE,A2:C2)&""""

View attachment 67217

EDIT: concatenate version: =""""&A2&""","""&B2&""","""&C2&""""

thanks, I will give this one a go next week

Take care of yourself!!

Kelli