software

Greetings. I have checked the help files, but I have not been able to find
the answer. I am using EXCEL 2003. I have several columns that contain only
quot;wordsquot; that do not require any calculations. Some quot;wordsquot; look like this:
quot; OWBI71YMquot; (but without the quotes). As you can see there is a plus sign in
front of the word. But this word appears like this in the column: quot;#NAME?quot;
(but without the quotes). What can I do to turn off all possible
calculations in these columns. I am new to EXCEL, so please explain in easy
English. Thanks.

Oops! I just realized I should have posted this in the New Users group. I
apologize.

quot;Rebeccaquot; wrote:

gt; Greetings. I have checked the help files, but I have not been able to find
gt; the answer. I am using EXCEL 2003. I have several columns that contain only
gt; quot;wordsquot; that do not require any calculations. Some quot;wordsquot; look like this:
gt; quot; OWBI71YMquot; (but without the quotes). As you can see there is a plus sign in
gt; front of the word. But this word appears like this in the column: quot;#NAME?quot;
gt; (but without the quotes). What can I do to turn off all possible
gt; calculations in these columns. I am new to EXCEL, so please explain in easy
gt; English. Thanks.


You would like the text to show exactly as entered. Select your range,
cell or cells, and right click, format, select the number tab, and
select text. This will display the text as

OWBI71YM

Jeremy--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=503595Hi. Thanks, but I already tried that. They still appear on screen as #NAME?.

quot;beechum1quot; wrote:

gt;
gt; You would like the text to show exactly as entered. Select your range,
gt; cell or cells, and right click, format, select the number tab, and
gt; select text. This will display the text as
gt;
gt; OWBI71YM
gt;
gt; Jeremy
gt;
gt;
gt; --
gt; beechum1
gt; ------------------------------------------------------------------------
gt; beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
gt; View this thread: www.excelforum.com/showthread...hreadid=503595
gt;
gt;

you may have to pre format a new column as text,copy and paste your data into
that,make sure the original cells are formatted for text and copy back
--
paul
remove nospam for email addy!
quot;Rebeccaquot; wrote:

gt; Hi. Thanks, but I already tried that. They still appear on screen as #NAME?.
gt;
gt; quot;beechum1quot; wrote:
gt;
gt; gt;
gt; gt; You would like the text to show exactly as entered. Select your range,
gt; gt; cell or cells, and right click, format, select the number tab, and
gt; gt; select text. This will display the text as
gt; gt;
gt; gt; OWBI71YM
gt; gt;
gt; gt; Jeremy
gt; gt;
gt; gt;
gt; gt; --
gt; gt; beechum1
gt; gt; ------------------------------------------------------------------------
gt; gt; beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=503595
gt; gt;
gt; gt;

Thanks, Paul, but that doesn't work either. I'm at a loss here.

quot;paulquot; wrote:

gt; you may have to pre format a new column as text,copy and paste your data into
gt; that,make sure the original cells are formatted for text and copy back
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Rebeccaquot; wrote:
gt;
gt; gt; Hi. Thanks, but I already tried that. They still appear on screen as #NAME?.
gt; gt;
gt; gt; quot;beechum1quot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; You would like the text to show exactly as entered. Select your range,
gt; gt; gt; cell or cells, and right click, format, select the number tab, and
gt; gt; gt; select text. This will display the text as
gt; gt; gt;
gt; gt; gt; OWBI71YM
gt; gt; gt;
gt; gt; gt; Jeremy
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; beechum1
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=503595
gt; gt; gt;
gt; gt; gt;


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

Regards
Mike--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: www.excelforum.com/member.php...oamp;userid=18570
View this thread: www.excelforum.com/showthread...hreadid=503595Thanks Mike, but no, the words have already been typed. I have merely pasted
them into the cells. Oh, well.

quot;Mikeopoloquot; wrote:

gt;
gt; If you are typing these words into the cell, put a single quote (') at
gt; the beginning. Any help?
gt;
gt; Regards
gt; Mike
gt;
gt;
gt; --
gt; Mikeopolo
gt; ------------------------------------------------------------------------
gt; Mikeopolo's Profile: www.excelforum.com/member.php...oamp;userid=18570
gt; View this thread: www.excelforum.com/showthread...hreadid=503595
gt;
gt;


I believe I have a solution for you.

Select the range of cells containing your problem.
Now choose Edit from the menu bar
Select Find
For quot;Find What:quot; type an equal sign by itself
Make sure you have Formulas selected for the quot;Look in:quot; drop down
Now click on the quot;Replacequot; button
For quot;Replace with:quot; leave it blank
Now click on the quot;Replace Allquot; button

That should do it

MAKE SURE THERE ARE NO FORMULAS IN YOUR SELECTED RANGE THAT YOU WANT TO
RETAIN AS FORMULAS--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=503595Rebecca

Toolsgt;Optionsgt;Transition.

Uncheck the options in lower part of dialog screen.

With these checked, Excel thinks the quot; quot; sign makes the entry a formula.Gord Dibben MS Excel MVP

On Sat, 21 Jan 2006 05:55:02 -0800, quot;Rebeccaquot;
gt; wrote:

gt;Thanks Mike, but no, the words have already been typed. I have merely pasted
gt;them into the cells. Oh, well.
gt;
gt;quot;Mikeopoloquot; wrote:
gt;
gt;gt;
gt;gt; If you are typing these words into the cell, put a single quote (') at
gt;gt; the beginning. Any help?
gt;gt;
gt;gt; Regards
gt;gt; Mike
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Mikeopolo
gt;gt; ------------------------------------------------------------------------
gt;gt; Mikeopolo's Profile: www.excelforum.com/member.php...oamp;userid=18570
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=503595
gt;gt;
gt;gt;