Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Add Zeros In Front Of Numbers

  1. #1
    Join Date
    12th September 2007
    Posts
    2

    Add Zeros In Front Of Numbers

    Hi,

    I have the following data as text in my file:

    5
    13
    108
    5525
    97875

    I would like the following results:
    00005
    00013
    00108
    05525
    97875

    So in other words, I would like to make the text 5 characters and when needed, insert zeros in front of the numbers. Is there any way to convert/insert zeros in front of the numbers to make them look like the results above? Appreciate your help.

    Thanks,
    Kishore

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    Re: Inserting Zeros In Front Of A Number

    Welcome to Oz, temp

    Format > cells > number > custom > 00000
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

  3. #3
    Join Date
    18th September 2005
    Location
    Hampshire, UK
    Posts
    1,278

    Re: Inserting Zeros In Front Of A Number

    If you already have the data entered as text, then you may need an intermediate formula to convert to the required format:

    =TEXT(A1+0,"00000")

    Assuming you have the A column formatted as text, you can then copy and paste values from the formulas back into your original column.

    Richard

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th September 2007
    Posts
    2

    Re: Inserting Zeros In Front Of A Number

    Thanks for the prompt reply guys. This is awesome to get such quick responses. I realized that I should not have these cells formatted as text. Otherwise, it won't work. Thank you so much Shg for your solution. You have made my day today. This will help me out alot in the future.

    Thank you guys. I'm coming back to this site all the time now.

    Kishore

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: June 18th, 2007, 23:20
  2. Replies: 4
    Last Post: August 22nd, 2006, 13:06
  3. Keep Zeros in front of numbers
    By ESB in forum EXCEL HELP
    Replies: 3
    Last Post: October 13th, 2005, 16:51
  4. Placing a + or - in front of numbers.
    By BLASTER in forum EXCEL HELP
    Replies: 1
    Last Post: June 2nd, 2004, 04:14
  5. Adding a ' in front of numbers
    By walshk79 in forum EXCEL HELP
    Replies: 6
    Last Post: March 21st, 2003, 08:10

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
  •  
porno