changing from auto to standard

I just purchased a 1992 honda prelude and I love the car except for one thing its an automatic I was wondering if anyone knows how much it will cost to convert from auto to standard. or what I could do to beef up the automatic to be able to hold it's own against a standard.