=A1*10^(6-LEN(A1))
--
David Biddulph

"A.S." wrote in message
...
I wanted to know if there is a formula that counts the number of digits in
a
cell then adds zeroes until there are 6 digits. For example,

1238
37830
38
782
628918

With formula would look like:
123800
378300
380000
782000
628918

Thanks,