At 13:08 27/02/2022 -0500, Vince Bonly wrote:
I must figure a way to convert existing cell contents such as (877)
300-1111 to the desired display format. Can this task be
accomplished using a formula?
Yup: =VALUE(MID(Xn;2;3)&MID(Xn;7;3)&MID(Xn;11;4))
- where Xn is the cell containing the original (text) entry. That
will give the number 8773001111, and you can format that in the way
you now want.
Alternatively, you could use Data | Text to Columns..., putting "()-"
(no quotes) in the Other box and ticking both Space and "Merge
delimiters". That returns the three numerical strings, still as text
items. Then you can concatenate these and convert them to a number
using the VALUE() function. Again, apply your desired format.
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
