Here's the trick how to do this:
In the phone number column I'll select the entire column or the cells I need the formatting on.
Right click the selected area and click Format Cells
In the Numbers tab, I insert the following as Format Code:
###" "##" "###
Make sure to add the space between the " and ".
Correctly inserted phone numbers should now look like: 123 45 789
(A lot better for my ageing eyes.)
.
No comments:
Post a Comment