Custom Formatting

[DM_Britams]

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

[#2]

Hi,

You can pre-set a whole column/s or a range of cells to apply this format.

Select a column, then press (Ctrl+1) to open the Format Cells, then select Custom and put the below format into the Type box, and then hit OK.

"0031"#

Hope that helps

[#3]

Sorry, I did not read your post well!

To keep the customized value, you have to use a formula to do that, and then convert the formula result to value only.

You could use this formula:

="0031"&A1

Or this:

="0031"&TEXT(A1,"000000000")

Regards

[#4]

Hi guys,

Sorry for not getting back to you! I was off for a few days. This is great stuff, thanks so much for taking the time to reply to me. I really appreciate it!

I will try it on Monday and will update my post with the result. Fingers crossed!