Thread: Using a = sign
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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