Results 1 to 6 of 6

Add 0 to the beginning of the cell

Threaded View

  1. 06-16-2005, 02:26 AM #1
    bklim
    bklim is offline
    Registered User
    Join Date
    06-13-2005
    Posts
    10

    Adding 0 to the beginning of the cell, to make the total no of digits becomes 10

    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
    Last edited by bklim; 06-16-2005 at 02:59 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1