Thread: #NAME? Problem
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default #NAME? Problem

Rebecca

ToolsOptionsTransition.

Uncheck the options in lower part of dialog screen.

With these checked, Excel thinks the "+" sign makes the entry a formula.


Gord Dibben MS Excel MVP

On Sat, 21 Jan 2006 05:55:02 -0800, "Rebecca"
wrote:

Thanks Mike, but no, the words have already been typed. I have merely pasted
them into the cells. Oh, well.

"Mikeopolo" wrote:


If you are typing these words into the cell, put a single quote (') at
the beginning. Any help?

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=503595