Convert to 8 digits

[kralimarko]

I have various numbers, and i want to convert them to numbers with 8 digits,
to add missing zero's at the end

ex.
7721 - to 77210000
77212 - to 77212000
77 - to 77000000

i need formula

Please help

thanks in advance

 

[pgc01]

Hi

Try:

=0+LEFT(A1&"00000000",8)

 

[Akashwani]

Hi

=VALUE(IF(LEN(A1)<8,(A1&REPT("0",8-LEN(A1)))))

Ak

Never mind, use pgc01's method.

 

[kralimarko]

thanks