I think this YouTube may answer most of your question: youtube.com/watch?v=QzmAq-x2KM0
On May 30, 2020 at 9:41:34 AM, WA.TWORSX via AOL (wa.two...@verizon.net.invalid) wrote: I have a Calc file that presently has telephone numbersexisting within a column. They were previously imported from a source that used the following format: 800 555 1234, and some cells are blank. How can I reformat the column and all existing numbers within the column to be in the form: (800) 555-1234? Be well; stay safe. VinceB. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org