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