counting and adding

[Guest]

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,

 

[David Biddulph]

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

 

[PCLIVE]

Try this:

=A1&REPT(0,6-LEN(A1))

HTH,
Paul

 

[Guest]

=(A1&REPT(0;6-LEN(A1)))*1


"A.S." skrev:

 

[Guest]

ups forgot it is (,) not (

=(A1&REPT(0,6-LEN(A1)))*1


"excelent" skrev: