Connecting Tech Pros Worldwide Help | Site Map

Add leading Zeros to number

jack
Guest
 
Posts: n/a
#1: Nov 20 '05
Hello,

I have a number that is 6 places long.

I would like:

"16" to be "000016"
"116" to be "000116"

and so on.

Any help whould be great!!

Thanks,

Jack


Mark Keogh
Guest
 
Posts: n/a
#2: Nov 20 '05

re: Add leading Zeros to number


Number.ToString.PadLeft(6, "0"c)



"jack" <jack@mrolinux.com> wrote in message
news:eG$Pm4CcDHA.856@tk2msftngp13.phx.gbl...[color=blue]
> Hello,
>
> I have a number that is 6 places long.
>
> I would like:
>
> "16" to be "000016"
> "116" to be "000116"
>
> and so on.
>
> Any help whould be great!!
>
> Thanks,
>
> Jack
>
>[/color]


jack
Guest
 
Posts: n/a
#3: Nov 20 '05

re: Add leading Zeros to number


Hello,

Thanks for the quick reply. How do I have the formating done on a var like
CounterCount?

Thanks,

Jack

"Mark Keogh" <no@email.com.au> wrote in message
news:%23VsM98CcDHA.1808@TK2MSFTNGP11.phx.gbl...[color=blue]
> Number.ToString.PadLeft(6, "0"c)
>
>
>
> "jack" <jack@mrolinux.com> wrote in message
> news:eG$Pm4CcDHA.856@tk2msftngp13.phx.gbl...[color=green]
> > Hello,
> >
> > I have a number that is 6 places long.
> >
> > I would like:
> >
> > "16" to be "000016"
> > "116" to be "000116"
> >
> > and so on.
> >
> > Any help whould be great!!
> >
> > Thanks,
> >
> > Jack
> >
> >[/color]
>
>[/color]


Mark Keogh
Guest
 
Posts: n/a
#4: Nov 20 '05

re: Add leading Zeros to number


Exactly the same,

CounterCount.ToString.PadLeft(6, "0"c)

HTH


"jack" <jack@mrolinux.com> wrote in message
news:#SKuaBDcDHA.2940@TK2MSFTNGP11.phx.gbl...[color=blue]
> Hello,
>
> Thanks for the quick reply. How do I have the formating done on a var[/color]
like[color=blue]
> CounterCount?
>
> Thanks,
>
> Jack
>
> "Mark Keogh" <no@email.com.au> wrote in message
> news:%23VsM98CcDHA.1808@TK2MSFTNGP11.phx.gbl...[color=green]
> > Number.ToString.PadLeft(6, "0"c)
> >
> >
> >
> > "jack" <jack@mrolinux.com> wrote in message
> > news:eG$Pm4CcDHA.856@tk2msftngp13.phx.gbl...[color=darkred]
> > > Hello,
> > >
> > > I have a number that is 6 places long.
> > >
> > > I would like:
> > >
> > > "16" to be "000016"
> > > "116" to be "000116"
> > >
> > > and so on.
> > >
> > > Any help whould be great!!
> > >
> > > Thanks,
> > >
> > > Jack
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]


jack
Guest
 
Posts: n/a
#5: Nov 20 '05

re: Add leading Zeros to number


Thanks!!!

"Mark Keogh" <no@email.com.au> wrote in message
news:eqaa1SDcDHA.2904@TK2MSFTNGP11.phx.gbl...[color=blue]
> Exactly the same,
>
> CounterCount.ToString.PadLeft(6, "0"c)
>
> HTH
>
>
> "jack" <jack@mrolinux.com> wrote in message
> news:#SKuaBDcDHA.2940@TK2MSFTNGP11.phx.gbl...[color=green]
> > Hello,
> >
> > Thanks for the quick reply. How do I have the formating done on a var[/color]
> like[color=green]
> > CounterCount?
> >
> > Thanks,
> >
> > Jack
> >
> > "Mark Keogh" <no@email.com.au> wrote in message
> > news:%23VsM98CcDHA.1808@TK2MSFTNGP11.phx.gbl...[color=darkred]
> > > Number.ToString.PadLeft(6, "0"c)
> > >
> > >
> > >
> > > "jack" <jack@mrolinux.com> wrote in message
> > > news:eG$Pm4CcDHA.856@tk2msftngp13.phx.gbl...
> > > > Hello,
> > > >
> > > > I have a number that is 6 places long.
> > > >
> > > > I would like:
> > > >
> > > > "16" to be "000016"
> > > > "116" to be "000116"
> > > >
> > > > and so on.
> > > >
> > > > Any help whould be great!!
> > > >
> > > > Thanks,
> > > >
> > > > Jack
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]


Herfried K. Wagner [MVP]
Guest
 
Posts: n/a
#6: Nov 20 '05

re: Add leading Zeros to number


Hello,

"jack" <jack@mrolinux.com> schrieb:[color=blue]
> I have a number that is 6 places long.
>
> I would like:
>
> "16" to be "000016"
> "116" to be "000116"
>
> and so on.
>
> Any help whould be great!![/color]

\\\
MsgBox(Format(16, "000000"))
///

HTH,
Herfried K. Wagner
--
MVP · VB Classic, VB .NET
http://www.mvps.org/dotnet


Closed Thread