+ Reply to Thread
Results 1 to 8 of 8

I need Excel to make "1" into "001"

  1. #1
    Registered User
    Join Date
    08-15-2005
    Posts
    14

    I need Excel to make "1" into "001"

    I'm making a ranking list in excel and now i want all numbers to be alligned when I copy them to a forum. In order to do that I need excel to make every number 3 figures, so for instance 1 becomes 001 and 85 becomes 085. There must be a way to do this automatically in excel, but how? Does anyone know?

    Thanks in advance,

    Cervantes

  2. #2
    Anne Troy
    Guest

    Re: I need Excel to make "1" into "001"

    Format-->Cells, Number tab, Choose Customer and type 000 into the short box
    at the right.
    ************
    Anne Troy
    www.OfficeArticles.com

    "Cervantes" <[email protected]> wrote
    in message news:[email protected]...
    >
    > I'm making a ranking list in excel and now i want all numbers to be
    > alligned when I copy them to a forum. In order to do that I need excel
    > to make every number 3 figures, so for instance 1 becomes 001 and 85
    > becomes 085. There must be a way to do this automatically in excel,
    > but how? Does anyone know?
    >
    > Thanks in advance,
    >
    > Cervantes
    >
    >
    > --
    > Cervantes
    > ------------------------------------------------------------------------
    > Cervantes's Profile:
    > http://www.excelforum.com/member.php...o&userid=26323
    > View this thread: http://www.excelforum.com/showthread...hreadid=483188
    >




  3. #3
    Johnny Naperville
    Guest

    RE: I need Excel to make "1" into "001"

    Format(<cell>,"000") will also work.

    "Cervantes" wrote:

    >
    > I'm making a ranking list in excel and now i want all numbers to be
    > alligned when I copy them to a forum. In order to do that I need excel
    > to make every number 3 figures, so for instance 1 becomes 001 and 85
    > becomes 085. There must be a way to do this automatically in excel,
    > but how? Does anyone know?
    >
    > Thanks in advance,
    >
    > Cervantes
    >
    >
    > --
    > Cervantes
    > ------------------------------------------------------------------------
    > Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323
    > View this thread: http://www.excelforum.com/showthread...hreadid=483188
    >
    >


  4. #4
    Registered User
    Join Date
    08-15-2005
    Posts
    14
    Thanks to the both of you for the quick replies

  5. #5
    Dave Peterson
    Guest

    Re: I need Excel to make "1" into "001"

    =text(a1,"000")

    ????

    Johnny Naperville wrote:
    >
    > Format(<cell>,"000") will also work.
    >
    > "Cervantes" wrote:
    >
    > >
    > > I'm making a ranking list in excel and now i want all numbers to be
    > > alligned when I copy them to a forum. In order to do that I need excel
    > > to make every number 3 figures, so for instance 1 becomes 001 and 85
    > > becomes 085. There must be a way to do this automatically in excel,
    > > but how? Does anyone know?
    > >
    > > Thanks in advance,
    > >
    > > Cervantes
    > >
    > >
    > > --
    > > Cervantes
    > > ------------------------------------------------------------------------
    > > Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323
    > > View this thread: http://www.excelforum.com/showthread...hreadid=483188
    > >
    > >


    --

    Dave Peterson

  6. #6
    Terry
    Guest

    RE: I need Excel to make "1" into "001"

    I just change cell format to text it works, however when I sort them latter,
    numerical data and text data they sory separately.

    Will the way you guys provide can deal the problem of latter sorting?




  7. #7
    Anne Troy
    Guest

    Re: I need Excel to make "1" into "001"

    Yep. The value is the sort order, not the display.
    ************
    Anne Troy
    www.OfficeArticles.com

    "Terry" <[email protected]> wrote in message
    news:[email protected]...
    >I just change cell format to text it works, however when I sort them
    >latter,
    > numerical data and text data they sory separately.
    >
    > Will the way you guys provide can deal the problem of latter sorting?
    >
    >
    >




  8. #8
    Registered User
    Join Date
    08-12-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    Re: I need Excel to make "1" into "001"

    Go to Excel Home
    Click on Number
    Click on Custom
    Click 0.00
    Edit it to 000
    Then go to your Excel work sheet cell
    type 1, automatically it will come as 001
    copy that cell to below in all cells. save it
    now delete all copied cells
    now start putting 2, 3, 4 ......
    it will come automatically as 001, 002, 003 ....

+ 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