Custom Number Format

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
 
B

Bob Phillips

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

GregR

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
 
G

GregR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Unable to format a control in a Userform 2
Possible Macro Solution To My Problem 4
Update query based on previous record 11
Table of content - format does not get saved 2
Number displayed as text difficulties 4
A list and chart from two pivot tables 0

Top