display:Custom Number Format

How do I display 882-9-172 as 882-009-00172, custom number format
"000-000-00000", keep or add any needed leading zero's. TIA

Greg

If the value has those - embedded, you have a problem as it is as text,
which won't format to a number format.

--
HTH

Bob Phillips

"GregR" <gregrivet@gmail.com> wrote in message
news:1129152564.560115.63510@g14g2000cwa.googlegroups.com...
> How do I display 882-9-172 as 882-009-00172, custom number format
> "000-000-00000", keep or add any needed leading zero's. TIA
>
> Greg
>

Bob, I was doing a concatenation and the formula
A1&"-"&Text(B1,"000")&"-"&Text(C1,"00000") worked. Even a blind
squirrel finds an acorn once in a while

Bob, I was doing a concatenation and the formula
A1&"-"&Text(B1,"000")&"-"&Text(C1,"00000") worked. Even a blind
squirrel finds an acorn once in a while