Re: Telephone Number Formatting

2020-05-30 Thread Brian Barker
At 11:41 30/05/2020 -0400, Vince Bonly wrote: I have a Calc file that presently has telephone numbers existing 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

Re: Telephone Number Formatting

2020-05-30 Thread David Belina
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

Telephone Number Formatting

2020-05-30 Thread WA.TWORSX via AOL
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:

Re: Number Formatting

2015-07-28 Thread Dale Erwin
On 7/28/2015 5:12 PM, Dale Erwin wrote: Environment: AOO 4.1.1 under Win 7. I am using a table in Writer for as tabulation because I want some columns left-justified and some columns right-justified. The right-justified columns contain dollars and cents. Every time I enter an amount that