Inlude the Country code to a regular phone number

[Antoan]

Hello everyone!

So as you can see from the description there my question is related to converting a regular phone number to including the country code to it. The regular phone numbers I have start with "0", however when i include the country code to it with a simple formula (="+380"&[@[phone_1]]) . However, the version with the country code included, should exclude the "0" from the regular number, otherwise its wrong and I coudnt use it.

Hope that explains a bit my case!


Looking foward to hearing from you!

Your contribution would be highly appreciated!

phone_1	phone_1.2
0347725311	+3800347725311
0442660693	+3800442660693
0442362605	+3800442362605
0342584568	+3800342584568
0462231544	+3800462231544
0484041740	+3800484041740
0512477717	+3800512477717
0313137680	+3800313137680

 

[Fluff]

Maybe

="+38"&[@[phone_1]]

 

[mohadin]

Too late

 

[JvdV]

Instead of text, why not a custom number format to display the text but maintain the possibility for calculations etc.

+38\00

 

[Antoan]

Maybe

="+38"&[@[phone_1]]

Man, so simple but yet so so hard for dump people like me haha. Thank you man, so smart!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Antoan]

Instead of text, why not a custom number format to display the text but maintain the possibility for calculations etc.

+38\00

Thank you so much for the help! Happily the above mentioned formula, should work perfectly here. However i will most likely experience problems further if i need to use another country code that doesn't end with "0". For some reason, i dont seem to understand the formula that you posted. Could you give me further clarification, how i can use it?
Thanks in advance!

 

[JvdV]

Thank you so much for the help! Happily the above mentioned formula, should work perfectly here. However i will most likely experience problems further if i need to use another country code that doesn't end with "0". For some reason, i dont seem to understand the formula that you posted. Could you give me further clarification, how i can use it?
Thanks in advance!

You shouldn't have any problems with other countrycodes not ending with zero. All this above formula does is:

* '+38' - Hardcode the leading mentioned pattern;
* '\0' - Hardcode a zero. Since a '0' has special meaning in number formatting we need to escape it to make it literal. This makes the total leading pattern '+380';
* '0' - As mentioned above, a zero has special meaning in number formatting. It is used to force the display of insignificant zeros when a number has fewer digits than zeros in the format.