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 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
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
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
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
- 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!
