+ Reply to Thread
Results 1 to 2 of 2

Format cells to add 3 zeros before my entered number

  1. #1
    Registered User
    Join Date
    07-04-2015
    Location
    Nevada
    MS-Off Ver
    MS OFFICE 365
    Posts
    43

    Format cells to add 3 zeros before my entered number

    I have to enter a EE number in a cell, and I have to make it 10 characters long which means I have to add 3 zeros at the beginning of the EE number. Is there a way to format the cells so it does this automatically??

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Format cells to add 3 zeros before my entered number

    You can custom-format the cell as 0000000000 which will make it appear to have 10 digits.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Custom Number Format with Leading Zeros (Greek)
    By Graham1 in forum Excel General
    Replies: 5
    Last Post: 01-22-2020, 11:30 PM
  2. Keep number format when converting to text - with decimal and zeros
    By tampagirl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2014, 06:34 PM
  3. Add Cell Custom Format after entered number
    By cosmarchy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 10:24 AM
  4. Variable number format before value entered
    By blaxal in forum Excel General
    Replies: 2
    Last Post: 09-24-2009, 01:20 AM
  5. Sedol Number Format Zeros
    By firefly2k8 in forum Excel General
    Replies: 6
    Last Post: 08-07-2009, 11:28 AM
  6. Replies: 4
    Last Post: 11-17-2005, 10:20 AM
  7. [SOLVED] zero supress leading zeros when chg format from text to number
    By HeatherO in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2005, 08:06 PM
  8. retain leading zeros in number format
    By Jeff in forum Excel General
    Replies: 5
    Last Post: 02-22-2005, 06:06 PM

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