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 |
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 |