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