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