Keali,
Is A1 a String or a Integer?
Have you tried the String.PadRight function?
Dim A1 As String = "123"
A1 = A1.PadRight(6, "0"c)
If A1 is an Integer, I'm not sure of a "better" (another) method then
converting to a string, using PadRight, and converting back.
Hope this helps
Jay
"keali" <ke*******@fastmail.fm> wrote in message
news:d3****************************@phx.gbl...
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.