Assuming the values as text in the imported Excel...

First search and replace . by nothing
Then search and replace , by .
and you should be able to go.

If not then send the file to me
append @hotmail.com to to_sheeloo to get my id.

"barrowhill" wrote:

Just been contacted by my son who living and working in Romania as an
accountant.
Their accounting software is Romanian and cannot export to Excel as used in
my son's firm.

They have provided him with a file in html which via a conversion program
has been copied into excel.

My son says that there is about 1500 lines and he would like to auto sum one
(or more) columns. The issue is how the Romanians represent there number
system i.e. "one thousand pounds and 99 pence" in UK representation iwould
be £1,000.99. In Romania this would (and is in the spreadsheet) be shown as
£1.000,99 i.e the comma's and dots are reversed.

How would one reverse this representation to enable an auto sum to be
performed.

Appreciate help in providing son with a resolution to his problem