converting xlsx to csv with no data change

%3CLINGO-SUB%20id%3D%22lingo-sub-1677980%22%20slang%3D%22en-US%22%3Econverting%20xlsx%20to%20csv%20with%20no%20data%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1677980%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20been%20advised%20to%20ask%20about%20my%20problem%20here.%26nbsp%3B%20i%20have%20an%20xlsx%20worksheet%20with%20uk%20and%20cyprus%20phone%20numbers%20on%20including%20the%26nbsp%3B%20dialing%20code%2C%20without%20the%2000%20and%20just%20a%20%2B.%20when%20i%20save%20as%20csv%20all%20looks%20ok%20however%20when%20i%20open%20it%20again%20i%20get%20random%20numbers%20with%20%2B11%20in%20in%20the%20UK%20numbers%20only.%26nbsp%3B%20i%20have%20spent%203%20days%20reading%20and%20watching%20videos%20and%26nbsp%3B%20tried%20many%20ways%20of%20formatting%20it%20but%20clearly%20i%20have%20missed%20something%20as%20i%20cant%20sort%20it.%26nbsp%3B%20any%20help%20and%20advice%20is%20greatly%20appreciated.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1677980%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1678262%22%20slang%3D%22en-US%22%3ERe%3A%20converting%20xlsx%20to%20csv%20with%20no%20data%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1678262%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F797223%22%20target%3D%22_blank%22%3E%40leeps02%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EHere's%20a%20workaround.%20There's%20probably%20other%20solutions...%3C%2FP%3E%3CP%3EFirst%2C%20Save%20a%20file%20as%20CSV.%3C%2FP%3E%3CP%3EThen%20format%20all%20your%20cells%20as%20Text%3C%2FP%3E%3CP%3EFinally%2C%20when%20you%20enter%20your%20phone%20numbers%2C%20add%20a%20space%20between%20the%20country%20code%20and%20the%20number%20like%20in%20the%20example%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1600348979689.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219149i59E196A9E03D3B2D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1600348979689.png%22%20alt%3D%22Bennadeau_0-1600348979689.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20worked%20for%20me%2C%20hopefully%20it%20will%20work%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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.