Sep 17 2020 05:17 AM
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
Sep 17 2020 06:23 AM
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.
That worked for me, hopefully it will work for you.