Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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 "words" that do not require any calculations. Some "words" look like this: "+OWBI71YM" (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: "#NAME?" (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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
Oops! I just realized I should have posted this in the New Users group. I
apologize. "Rebecca" wrote: 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 "words" that do not require any calculations. Some "words" look like this: "+OWBI71YM" (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: "#NAME?" (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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
Hi. Thanks, but I already tried that. They still appear on screen as #NAME?.
"beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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! "Rebecca" wrote: Hi. Thanks, but I already tried that. They still appear on screen as #NAME?. "beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
Thanks, Paul, but that doesn't work either. I'm at a loss here.
"paul" wrote: 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! "Rebecca" wrote: Hi. Thanks, but I already tried that. They still appear on screen as #NAME?. "beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
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 "Find What:" type an equal sign by itself Make sure you have Formulas selected for the "Look in:" drop down Now click on the "Replace" button For "Replace with:" leave it blank Now click on the "Replace All" 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: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
Edit the cell and remove the +.
Excel thinks you are trying to enter a formula. -- Damon Longworth 2006 East Coast Excel User Conference April 19/21st, 2006 Holiday Inn, Boardwalk Atlantic City, New Jersey Early Bird Registration Now Open!! www.ExcelUserConference.com 2006 UK Excel User Conference Summer, 2006 London, England "Rebecca" wrote in message ... Thanks, Paul, but that doesn't work either. I'm at a loss here. "paul" wrote: 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! "Rebecca" wrote: Hi. Thanks, but I already tried that. They still appear on screen as #NAME?. "beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
They can't be removed because they are part of the "words." This might be a
useful feature in Office 12, namely, you can turn off the calculation function for words that have a minus, plus, etc., sign in front of them, though such cases will be rare, of course. My two cents. "Damon Longworth" wrote: Edit the cell and remove the +. Excel thinks you are trying to enter a formula. -- Damon Longworth 2006 East Coast Excel User Conference April 19/21st, 2006 Holiday Inn, Boardwalk Atlantic City, New Jersey Early Bird Registration Now Open!! www.ExcelUserConference.com 2006 UK Excel User Conference Summer, 2006 London, England "Rebecca" wrote in message ... Thanks, Paul, but that doesn't work either. I'm at a loss here. "paul" wrote: 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! "Rebecca" wrote: Hi. Thanks, but I already tried that. They still appear on screen as #NAME?. "beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Problem
Try this, select the name errors by pressing F5, click special and select
formulas and uncheck everything but errors, click OK, then press ctrl + H, in the find what box type =+ and in the replace with box type '+ so replace equal sign plus sign with apostrophe and plus sign select replace all -- Regards, Peo Sjoblom Portland, Oregon "Rebecca" wrote in message ... They can't be removed because they are part of the "words." This might be a useful feature in Office 12, namely, you can turn off the calculation function for words that have a minus, plus, etc., sign in front of them, though such cases will be rare, of course. My two cents. "Damon Longworth" wrote: Edit the cell and remove the +. Excel thinks you are trying to enter a formula. -- Damon Longworth 2006 East Coast Excel User Conference April 19/21st, 2006 Holiday Inn, Boardwalk Atlantic City, New Jersey Early Bird Registration Now Open!! www.ExcelUserConference.com 2006 UK Excel User Conference Summer, 2006 London, England "Rebecca" wrote in message ... Thanks, Paul, but that doesn't work either. I'm at a loss here. "paul" wrote: 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! "Rebecca" wrote: Hi. Thanks, but I already tried that. They still appear on screen as #NAME?. "beechum1" wrote: 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=503595 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |