Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
Make copy from any document into Excel a right click with a drop . | Excel Worksheet Functions |