| 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
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) | |||
Hybrid Mode
