Home

Excel Formatting

DM_Britams
New Contributor
Hi guys,
I have used custom formatting to add the country code to a number cell. So for eg. Original was 6123456789 and I have customised using 0031000000000 to get result 00316123456789. However, I now want the cell value to be 00316123456789 and not keep the old value. This makes it easier when uploading telephone contact lists. At the moment, when I do this, it changes the value back to the original.

Do you know how I can convert the cell value permanently?

Many thanks for your time and input!
Gemma
1 Reply

I do not think this is possible with cell formatting as this option only deals how your value is being shown not the value it self. However you can add a helper column and create a formula like this (assuming your numbers are located in column A):

="0031" &A1

to convert your number to a string starting with 0031. If you need this to be a number then you can try below formula:

=("31&A1)*1

however this time you need to change cell formatting to show this number as desired.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies