PDA

View Full Version : "remove formula from cell"



Ago
03-11-2008, 02:44 PM
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
03-11-2008, 03:07 PM
Precede the = with a ' (single apostrophe).

Ago
03-11-2008, 03:26 PM
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
03-11-2008, 03:40 PM
It won't. But why not?

Ago
03-12-2008, 02:35 PM
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
03-12-2008, 02:41 PM
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.