If you only need to display it (format it) that way, then in the cell format
choose Custom and make the custom format 0000000000.

If you actually need to convert the value;
=Right("0000000000"&A1,10) - worksheet formula
=Right("0000000000"&MyVar) - VBA, where MyVar is the variable with the
original figure in it.


"bklim" wrote:


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