adding function

[Guest]

Hello,

How can I add "00" & "0" to the the following cells:
(A B ) Result C D
(1 72 ) 001 072


Regards,

 

[Guest]

Try a custom format of 000

Mike

 

[Domenic]

Try...

C1, copied to D1:

=TEXT(A1,"000")

Hope this helps!