Hello,

Hope someone can help with this!

I am exporting content into excel, where alot of the data contains
'='. Excel is then using the formula on this data and so '#VALUE!' is
appearing in every cell.

But I just want the content I am exporting to appear as is, without
excel using it's formulas on the data.

For example one of the cells data is:

=B1:L10-A11:I15

but Excel is displaying it as #VALUE!

but I just want it to be displayed as: =B1:L10-A11:I15

I have tried Paste Special, and setting Cell format to Text but still
no joy???

Is there a way to turn off Excel formulas or another way around this?

Thanks in advance for any help on this!!