Forum Discussion
Custom Formatting
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 ...
Sorry, I did not read your post well!
To keep the customized value, you have to use a formula to do that, and then https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9.
You could use this formula:
="0031"&A1
Or this:
="0031"&TEXT(A1,"000000000")
Regards