Hi Hilmar.

I thought I might have to do something like that... the only thing is that the Excel spreadsheet contains about 30,000 lines and there could be a no. of such formulae.

I was hoping there might have been an easier way !!!

regards,

Gerard



>>Hi.
>>I have set up a routine to import a file from Excel, but notice that if one of the columns is a calculated field (e.g. = Round(A1 / 100,2) , funny characters get into the imported field.
>>
>>Anybody know of a way round this ?
>>
>>Regards,
>>
>>Gerard
>
>Perhaps you might use the Copy & Paste Special commands in Excel first, to paste the values only, into another range.