Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Add Zeros In Front Of Numbers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Inserting Zeros In Front Of A Number

    Welcome to Oz, temp

    Format > cells > number > custom > 00000
    Entia non sunt multiplicanda sine necessitate.

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X