Insert two Columns at the right of the numbers.
Select the range of numbers i.e. "A:A"
Then go to DATA Text to Columns Delimited
Uncheck all checked and then select "Other and put a "." in the space
provided (without the "")
Then Click Finish.
You'll have on B:B all the data before the point.
In Colum C Row 1 you can put =A1&"."&B1 to get the numbers together
again.
Saludos
NlCO
--
NlCO
------------------------------------------------------------------------
NlCO's Profile:
http://www.excelforum.com/member.php...o&userid=26123
View this thread:
http://www.excelforum.com/showthread...hreadid=401416