Custom Number Format

  • Thread starter Thread starter GregR
  • Start date Start date
G

GregR

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.
 
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
 
Back
Top