converting xlsx to csv with no data change

Copper Contributor

HI 

i have been advised to ask about my problem here.  i have an xlsx worksheet with uk and cyprus phone numbers on including the  dialing code, without the 00 and just a +. when i save as csv all looks ok however when i open it again i get random numbers with +11 in in the UK numbers only.  i have spent 3 days reading and watching videos and  tried many ways of formatting it but clearly i have missed something as i cant sort it.  any help and advice is greatly appreciated. Thanks

1 Reply

Hi @leeps02,

Here's a workaround. There's probably other solutions...

First, Save a file as CSV.

Then format all your cells as Text

Finally, when you enter your phone numbers, add a space between the country code and the number like in the example below.

Bennadeau_0-1600348979689.png

That worked for me, hopefully it will work for you.