To convert numbers to text strings with leading 0's, use the formula like
=TEXT($A2,"0000000000")

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"bklim" wrote in
message ...

Dear Excel experts

12345 - 0000012345
12 - 0000000012
432567 - 0000432567
9 - 0000000009
4444444444 4444444444

The 1st column shows the original figures. I wish to add "0" to the
beginning of the cell to make the total number of digit becomes 10,
what would be the formula? Please advise.

Thank you in advance.

Regards/Mike


--
bklim
------------------------------------------------------------------------
bklim's Profile:
http://www.excelforum.com/member.php...o&userid=24268
View this thread: http://www.excelforum.com/showthread...hreadid=379590