thanks so much for your reply.

The exact data that is in the cell is the word "selected". I want to convert
all "selected" in the cells to a number. e.g. that excel automatically
converts the word once it is entered in the cell. So if I would type in
"selected" in the cell, it would change it automatically to a 1.

Thanks

"RagDyer" wrote:

I might have mis-read your post when you said to replace text with numbers.
My suggestion returns text that looks like a number.

If you need an actual number, as recognized by XL, post back with the
configuration of the data *after* it's in XL.

That is, exactly what data is in an individual cell?

The entire Answer, or just the parenthesis, or the Yes and No together with
the parenthesis ... or what?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Try using "Edit - Replace"

In "Find What", enter:
<Space(select)<Space

"Replace with:
<Space(1)<Space
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Greta" wrote in message
...
I have imported data from a survey tool into Excel. Unfortunately,
instead
of
importing the selected fields in a question with a number, it is
imported
and
shown as text (i.e. Question 1: Yes ( ), No (selected) instead of :
Yes( )
No
(1))

Can anyone tell me how I can program the cells that they automatically
convert the text (selected) into a number?

Thanx