adding function

John · Apr 3, 2007

Hello,

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

Regards,

Mike · Apr 3, 2007

Try a custom format of 000

Mike

Domenic · Apr 3, 2007

Try...

C1, copied to D1:

=TEXT(A1,"000")

Hope this helps!