+ Reply to Thread
Results 1 to 2 of 2

Custom Format Not Working - Need Leading Zero

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    Chicago
    MS-Off Ver
    Excel 365
    Posts
    93

    Custom Format Not Working - Need Leading Zero

    I have an ID that is used in my spreadsheet with the following custom format:
    ##-#####-###

    End result:
    01-01234-001
    14-01234-002

    I want the user to enter the numbers and then this format will enter the dashes. That works fine, but something else doesn't.
    When the ID starts with a single digit, I want the format to enter the leading zero.
    Yes - 01-12345-001
    No - 1-12345-001

    How can this be done?

    Thank you in advance!

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Custom Format Not Working - Need Leading Zero

    change the # to 0 which should do the job.

    00-00000-000
    Say thanks, click *

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1