Editing Cell Formatting in an Existing (Damaged?) Macro

I have a macro that pulls data from a report and sorts it into appropriate columns with specific formatting. Some formulas and calculations are employed, etc. Problem is that it is accessible on a shared drive and somebody who used it a week ago accidentally saved over the existing *.xlsm instead of saving as an *.xlsx, so some of the formatting is damaged (simple things, like cell fill color, formatting cells as dates or numbers). I'm not familiar too much with macros (I didn't create this one), but I would like to fix the formatting without further damaging it.

Is there an easy way to restore the formatting without having to manually edit VB code? My logic is that if it can be broken by saving over it, it can be fixed and then saved again.

Many thanks.