for example:
A1 = 123
A1=123000 <- final result

A1 =1234
A1=123400<- final result

A1=1
A1=100000<-final result

How do i append trailing zero? is there a function that i
can use for this?
i cannot use format(A1,"000000") because it append zero in
front.

Keali wrote:

> for example:
> A1 = 123
> A1=123000 <- final result
>
> A1 =1234
> A1=123400<- final result
>
> A1=1
> A1=100000<-final result
>
> How do i append trailing zero? is there a function that i
> can use for this?
> i cannot use format(A1,"000000") because it append zero in
> front.

What is A1? If it is a string, look at PadRight(int, char).

--
Tom Porterfield
MS-MVP MCE
http://support.telop.org

Please post all follow-ups to the newsgroup only.

Keali <(E-Mail Removed)> wrote:
> for example:
> A1 = 123
> A1=123000 <- final result
>
> A1 =1234
> A1=123400<- final result
>
> A1=1
> A1=100000<-final result
>
> How do i append trailing zero? is there a function that i
> can use for this?
> i cannot use format(A1,"000000") because it append zero in
> front.

Use a1 = a1.PadRight(6, '0');

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too