Re: Telephone Number Formatting
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 numbers within the
column to be in the form: (800) 555-1234?
Let's say your values are in column A, starting in row 1.
o In row 1 of a spare column, enter:
=IF(A1="";"";"("(A1;3)&")"(A1;4;4)&"-"(A1;4))
o Fill that formula down the new column.
o If desired, select the new column, copy (or cut) it, and paste it
back over the original data - but using Paste Special... (or
Ctrl+Shift+V) instead of normal Paste and ensuring that Formulae is
not ticked in the Paste Special dialogue.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Telephone Number Formatting
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
Telephone Number Formatting
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
Re: Number Formatting
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 ends in .00, it eliminates the two zeroes. For instance, if I enter 27.00, after I tab out of that column it changes to 27 (right-justified). If I click on 'Undo Auto Format' the 27.00 is restored, but the cursor is put back into the cell and getting out of the cell once again changes it to 27 (right justified). I have searched the table properties, but cannot find the control for this. Can someone please tell me where to find it? Dale Erwin Never mind... I found it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
