Replace #VALUE! with contents of cell??
 

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!!

Replace #VALUE! with contents of cell??
 

Hi

One you have imported the data, you could use EditFind & Replace
Control+H to bring up the dialogue box
Replace =
With '=
Click replace All.

This will place a single quote in front of all = signs and prevent Excel
treating them as formulae.

--
Regards

Roger Govier


"MOK" wrote in message
ups.com...
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!!