I would use Data TextToColumns, using the decimal as the delimiter and in
C1 put this formula and copy down, (note, column C must be formatted for
three place decimals...........

=(A1&".00"&B1)*1

Vaya con Dios,
Chuck, CABGx3



"sr25" wrote:

I have the column with the data 1234.1 or 12345678.1 and I would like to
change them adding 00 zeros right after the period and the result should be
1234.001 Any help is appreciated.