Michael wrote:
David H. Lipman wrote:
From: "Wade Smart" <[email protected]>
| Im not sure what to call it but, I would like to be able to enter say a
| telephone number into a cell like this xxxyyyzzzz and it be
autoformated
| to xxx-yyy-zzzz.
In some applications (like Adobe Life Cycle Desgner) this is known as
the "pattern".
Click:
Format
Cell
Number
Type in or copy and paste the following in the format code field:
[<=9999999]###-####;\(###") "###-####
You can then edit the comment from "user defined" to "Phone Number" and
reuse the format in later spreadsheets.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Michael, that is great. Thanks for that.
Im going to work on adapting that to my other inputs as well.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
