If you are trying to do this in a worksheet function use =text(A1,
"0000000")
This will format the number to always have seven digits to the left of
the decimal point.

If you want to just type it in the cell and have it keep the zeros type
a ' in front of the number like '0045343. The apostrophe just tells
excel to treat those zeros as text and will not print or even show in
the cell.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395510