Using a = sign

D

Dean

I need to use an equal sign as a constant and get an #Value error. I have
preceeded the equal sign with a single quote ' and surrounded it with double
quotes but still get the error. Any ideas???
 
D

Dave Peterson

Like in a cell by itself.

Either preformat the cell as text, then type: =

or type:
'=
(notice the leading apostrophe. It forces excel to treat the entry as text.)
 
C

CLR

Maybe try a leading SPACE before the equal sign...........

Vaya con Dios,
Chuck, CABGx3
 
Top