Hi Gordiva

Format the cell as 000000

This is how you can do it:

Right click the cell and select format. In the pop up window in the
number tab you have a list of various formats. Select "custom" at the
end of the list. Once you select custom you get a list of custom
formats and you will see a text box just below "Type" which would show
"General" by default. Replace this with 000000 ( zero 6 times) and
click OK.. And what you get is the number in the required format.

Thanks
Karthik bhat
Bangalore