Hi, I'm buying my very first car soon. It's my Mom's friend's, it has 166k on it, its a 91 (with bad paint job

), but unfortunately it is an automatic :\ I'm interested as wether or not it is possible to change the transmission from automatic to manual? I have a couple good friends who's parents work in auto-body shops and body shop so i will be able to get a good price on any work that needs to be done.
I'm looking forward to buying it for $800 and fixing it up, but i really want it to be a stick.
Thanks for any help in advance
Andy