‘ added to my phone number column with csv download

[BrianI]

Hi All,

Hopeing to get some help solving a very annoying problem I have. 

I have a data table that I need to export as a csv fine but when I do this my phone number column which is in the +61 format has a ' added to the start of it. 

if I export as an xlxs file it does not do it but then I have to open and re-save the document each time. 

Any advice on how I can stop the ' being added?

Thanks in advance

[BrianI]

Is anybody aware of a solution for this one?

[amitchandak]

@BrianI , Just make that column is text column and if needed give a data category

[BrianI]

Didn't work unfortunately.

I changed it to text and set a data catagory.

the value I have in the table is +61410999999 but the output I get from the csv file is '+61410999999