Try this if you want to insert "0":
=TEXT("0"&H2,REPT(0,LEN(H2)+1))
and this, if you want to insert "1":
=TEXT("0"&H2,REPT(0,LEN(H2)+1))

Regards,
Stefi

€žwebfort€� ezt Ã*rta:


hi, thanks for the reply, it keeps saying you have entered to too few
arguments for this function?

Thanks


--
webfort
------------------------------------------------------------------------
webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964
View this thread: http://www.excelforum.com/showthread...hreadid=543232