On Dec 22, 5:02*am, "Max" wrote:
wrote
Any suggestions, resources or perhaps solutions on how I can convert
text into numbers on excel 2007? I have a column on my excel sheet and
it has the text "Positive" and I want to convert that into 1?

You could try Edit Replace

Steps in xl2003
(I don't know/have xl2007)

Select the col
Click Edit Replace,
set it as:
Find: Positive
Replace with: 1
Click to Replace All
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
--- *

Dude, you are the Man...I am not quite sure why I wasn't thinking more
in a simple manner.......