EXCEL CHANGE TELEPHONE NRS

%3CLINGO-SUB%20id%3D%22lingo-sub-2926545%22%20slang%3D%22en-US%22%3EEXCEL%20CHANGE%20TELEPHONE%20NRS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2926545%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20it%20is%20the%20first%20time%20I%20am%20asking%20for%20help.%20I%20have%20a%20list%20of%20telephone%20nrs%20that%20I%20must%20take%20the%2027%20infront%20of%20South%20Africas%20telephone%20nrs%20away%20to%20put%20it%20into%20another%20system.%20I%20try%20to%20change%20it%20with%20numbers%2C%20first%20go%20to%20special%20and%20change%20to%20United%20states%20and%20then%20telephone%20nrs.%20Then%20go%20to%20numbers%20again%20with%20custom%20and%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2926545%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2927924%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGE%20TELEPHONE%20NRS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1206887%22%20target%3D%22_blank%22%3E%40Adri_Rasadriras53%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChanging%20format%20you%20only%20change%20how%20phone%20numbers%20are%20shown%20in%20Excel%2C%20their%20values%20will%20be%20the%20same.%20Better%20to%20use%20formulas%20as%20TEXT()%20and%20paste%20resulting%20texts%20into%20another%20system.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi it is the first time I am asking for help. I have a list of telephone nrs that I must take the 27 infront of South Africas telephone nrs away to put it into another system. I try to change it with numbers, first go to special and change to United states and then telephone nrs. Then go to numbers again with custom and 

1 Reply

@Adri_Rasadriras53 

Changing format you only change how phone numbers are shown in Excel, their values will be the same. Better to use formulas as TEXT() and paste resulting texts into another system.