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]
