Using a = sign

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

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.)



Dean wrote:
>
> 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???

--

Dave Peterson

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

Vaya con Dios,
Chuck, CABGx3



"Dean" <[email protected]> wrote in message
news:[email protected]...
> 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???