How to disable Macros in spread sheet…?

Hi Guys I want to disable a macro in spread sheet it wont let me do it as when I try to take out the formula from the spread sheet the data also disappears how can I disable the macro but keep the data Please Help!!!!!