ups forgot it is (,) not (;)

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


"excelent" skrev:

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


"A.S." skrev:

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,