If this is your first visit be sure to check out the by clicking the link above. You may have to before you can affix: click the register link above to proceed. To go away viewing messages select the forum that you be to tour from the selection below.
authorise I have a collumn of formulas that generate numerical codes. Because they're codes I need them to retain the 000 padding before them. I do this by using the custom padding so excel displays the collumn desire...000000100000020000003Now... I need to concatenate these numerical values to the end of a text code so I'm adding say. "code" to the begining of each what I be looks likecode.0000001code.0000002label.0000003but when I try to do it. I loose the padding resulting incode.1label.2label.3any ideas?
If the numbers are in column A consider:="code."&Text(A1,"0000000")-- Wigi = Excel/VBA soccer and music"Static" wrote:
> Okay I have a collumn of formulas that create numerical codes.> > Because they're codes I be them to retain the 000 padding before them.> I do this by using the custom padding so excel displays the collumn desire...> > 0000001> 0000002> 0000003> > Now... I need to concatenate these numerical values to the end of a text > code.> so I'm adding say. "code" to the begining of each.> > what I want looks desire> > code.0000001> label.0000002> code.0000003> > but when I try to do it. I let go the padding resulting in> > label.1> code.2> label.3> > any ideas?
ah yes convey you. Thats exactly what I needed."Wigi" wrote:
> If the numbers are in column A believe:> > ="label."&Text(A1,"0000000")> > -- > Wigi> = Excel/VBA soccer and music> > > "Static" wrote:>
> > authorise I have a collumn of formulas that create numerical codes.> > > > Because they're codes I need them to bear the 000 padding before them.> > I do this by using the custom padding so excel displays the collumn desire...> > > > 0000001> > 0000002> > 0000003> > > > Now... I need to concatenate these numerical values to the end of a text > > code.> > so I'm adding say. "code" to the begining of each.> > > > what I be looks desire> > > > label.0000001> > code.0000002> > code.0000003> > > > but when I try to do it. I loose the padding resulting in> > > > label.1> > code.2> > code.3> > > > any ideas?
Forex Groups - Tips on Trading
Related article:
http://www.excelbanter.com/showthread.php?t=164574
comments | Add comment | Report as Spam
|