Hi Eddie,

Am Tue, 2 Aug 2011 22:04:24 +1000 schrieb Eddie O'Shea:

A friend has entered a long list of amounts in a column in Excel 2003.
Unfortunately, he entered the figures as set out below and Excel thinks the
numbers with a fullstop after the thousands are text:
1.234.56
3.567.89
354.87

the values are in column A, then try in another column:
=IF(LEN(A1)6,SUBSTITUTE(A1,".",",",1),A1)
Copy the new column and then paste values to the origin place


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2