Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 8th 05, 05:11 PM
Cervantes
 
Posts: n/a
Default 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


--
Cervantes
------------------------------------------------------------------------
Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323
View this thread: http://www.excelforum.com/showthread...hreadid=483188


  #2   Report Post  
Old November 8th 05, 05:19 PM
Anne Troy
 
Posts: n/a
Default 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" wrote
in message ...

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   Report Post  
Old November 8th 05, 05:26 PM
Johnny Naperville
 
Posts: n/a
Default 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   Report Post  
Old November 8th 05, 05:38 PM
Cervantes
 
Posts: n/a
Default I need Excel to make "1" into "001"


Thanks to the both of you for the quick replies


--
Cervantes
------------------------------------------------------------------------
Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323
View this thread: http://www.excelforum.com/showthread...hreadid=483188

  #5   Report Post  
Old November 8th 05, 06:05 PM
Dave Peterson
 
Posts: n/a
Default 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   Report Post  
Old November 8th 05, 08:12 PM
Terry
 
Posts: n/a
Default 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   Report Post  
Old November 8th 05, 08:14 PM
Anne Troy
 
Posts: n/a
Default I need Excel to make "1" into "001"

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

"Terry" wrote in message
...
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?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel, when column A and B have same name make column C add up in mail merge Dani B via OfficeKB.com Excel Discussion (Misc queries) 6 July 22nd 05 07:43 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA AliceJDavidson Excel Worksheet Functions 1 May 9th 05 09:30 PM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM
Make copy from any document into Excel a right click with a drop . Kat Excel Worksheet Functions 0 December 4th 04 12:43 AM


All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017