counting and adding

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
Back
Top