Pages

Thursday, January 16, 2014

Formatting phone numbers in LibreOffice

Every now and then I need to setup a list containing phone numbers in Libre Office Calc. When the phone numbers are listed I need to have them formatted in 3+2+3 digits. (Or else I'm unable to separate the digits when I am going to make the call.)

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