Custom Formatting
Start with 12345678901 in a cell. Then:
Format Cells Custom "A"000-0000-0000
Don't manually enter the "A", let the formatting do it.
--
Gary''s Student - gsnu200779
"cliff" wrote:
Hi, I need to format text and numbers, but I keep messing up.
For example, I want to format
A12345678901 so that it will appear as
A123-4567-8901
Please help?
|