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