ExcelBanter - Custom Number Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Custom Number Format (https://www.excelbanter.com/excel-programming/342616-custom-number-format.html)

GregR

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

Bob Phillips[_6_]

Custom Number Format

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" wrote in message
ups.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

GregR

Custom 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

GregR

Custom 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

All times are GMT +1. The time now is 01:59 PM.