View Single Post
  #2   Report Post  
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