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