>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)