>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 !!!
Perhaps there is, I am not sure.
Anyway, you could just select everything, and Copy & "Paste Special" into a new spreadsheet.
If you need to do this once, it should be fairly quick to do it manually.
If you need to do this on a regular basis, you should use Automation, to invoke it automatically from VFP.
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)