counting and adding
 

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,

counting and adding
 

=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,

counting and adding
 

Try this:

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

HTH,
Paul

"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,

counting and adding
 

=(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,

counting and adding
 

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,