At 19:53 24/02/2022 -0500, Keith N. McKenna wrote:
Format the cell as text and enter the characters as you want them to be displayed.
But that doesn't address the problem I understood the questioner to be posing: he wants, I think, to be able to enter just the ten digits and have the punctuation appear as if by magic. A suitable cell format does that - and entering data that way is less prone to error in the formatting. Isn't that what cell formatting is all about?
As Brian stated, Entering the way you want are not numeric values, but text.
An alternative way that creates text values would be to enter the plain ten-digit values into one column and to create a suitable formula in another column to extract the appropriate parts and add the punctuation. The unwanted entry column could then be hidden or have the reformatted values pasted over it, or it could have been placed elsewhere, perhaps even on another sheet.
Brian Barker
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
