create new helper column and enter:
=TEXT(A1*1000,"0000000")
You could also Copy and Paste-Special Value
to rid yourself of the formula afterwards..
Jim

"KeMet" wrote:

I have two colums of cells where I need the decimal point in the value
eliminated. I am importing weekly hours worked and weekly overtime hours
worked from a text file. They are imported in this fashion, 80.00 and 1.18
for overtime. I have to use the custom function to format the data like this:
0080.0000 and 0001.180. I do not need the decimal points (and I don't want to
round the values), but I still need the data as 0080000 and 0001180.
Any help on this is most appreciated.

Thanks,
Kyle