"remove formula from cell"

[Ago]

when my macro copys in a value to my cells and the value starts with = (equalsign), excel will give the errormessage =name? in green text.
how can i disable this?
i dont use any formulas anywhere in the sheet so i dont mind blocking them all, but the problem is only occuring in column E.

same thing happens when the value is numbers only, it will ask me if i want to convert it in to numbers (currently set to text).

what i would like to do is to tell excel and microsoft i know what im doing but with more cussing involved

any ideas?


EDIT: to give you guys some background info, the macro is a delimiter-script that seperates the values from column A to nine other coulmns

[Bob Phillips]

Precede the = with a ' (single apostrophe).

[Ago]

i cant let the ' stay there, but maybe it works if i first put in the ' and then removes it.
i will try that tomorrow, very tired now

[Bob Phillips]

It won't. But why not?

[Ago]

noticed it didnt help.
i cant have the ' there because i later use a macro that depends on the value of that cell.
i guess i have to find a way around this problem somehow.

thanks for the help!

[Bob Phillips]

How about insertuing the formula, but just flipping the Formula view, Tools>Options>View, Formulas checkbox. You can then flip it back when you need formulae.