How to automatically change a cell using Macro's

Michael - Feb 24, 2015 at 07:22 PM

I have a spreadsheet that has a whole bunch of "½" in it that excel doesn't recognize as the number "0.5". Currently I have to manually change them for excel to recognize it. Is there any way to write a macro so when there is a ½ in a sheet it will automatically change to 0.5? Please note, that all of these numbers have a full number in front of it like 6½ and I want to change it to 6.5.

If you can't do it for the entire excel can you just do a macro for a cell I select? I would prefer the entire spreadsheet though. Thank you!!!!