| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell custom Number format | Excel Worksheet Functions | |||
| convert number to % using only custom number format challenge | Excel Discussion (Misc queries) | |||
| Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
Hybrid Mode
