Results 1 to 3 of 3

Thread: How to make 1 to 001 in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    83

    How to make 1 to 001 in Microsoft Excel

    I am making a ranking list in excel and now i want all numbers to be aligned 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.

  2. #2
    Join Date
    Aug 2011
    Posts
    460

    Re: How to make 1 to 001 in Microsoft Excel

    It can be done via Format > Cells, Number tab, Choose Customer and type 000 into the short box at the right. Or else you can try Format(<cell>,"000") will also work.

  3. #3
    Join Date
    Jul 2011
    Posts
    434

    Re: How to make 1 to 001 in Microsoft Excel

    Many modifications can be done by rightclicking > Format Cell > and then modifying the cell settings to define properly the digits and other stuff. The modification is not tough but there are number of things you can try out it.

Similar Threads

  1. How to make a Schematic in Microsoft Excel
    By vALaNCiA in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 05:10 PM
  2. Replies: 2
    Last Post: 01-02-2012, 07:10 PM
  3. Replies: 2
    Last Post: 18-01-2012, 06:55 PM
  4. Need help to make collapsing section in Microsoft Excel
    By Jaques Strapp in forum MS Office Support
    Replies: 2
    Last Post: 11-01-2012, 12:09 PM
  5. Replies: 4
    Last Post: 13-02-2011, 10:37 AM

Tags for this Thread

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
  •  
Page generated in 1,711,647,687.86647 seconds with 17 queries