If you are entering the data by hand, simply pre-format the cell(s) as TEXT,
or type a preceeding apostrophe before the data

Vaya con Dios,
Chuck, CABGx3


"dyukon" wrote:


I need to create zero's in front of number and after number. For
example if the value is 12500. I need to have it look like
000012500000. Please help!


--
dyukon
------------------------------------------------------------------------
dyukon's Profile: http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=500660