="00"&INT(A1)&INT((A1-INT(A1))*100)

Vaya con Dios,
Chuck, CABGx3



"snickers22" wrote:

In one column, I have numbers with two decimal points, i.e. 55.42. In the
next column I need to take the decimal point out and add to zeros like this
"005542". Anyone know if there is a function that would do this?