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