When I export sheets from databases or Crystal reports, normally none of the
formatting buttons on the sheet work. To change decimals, or $ I have to go
to the format/cell. Or I copy the sheet and past values on a new sheet.

is there any way to clear whatever it brings with it so it works?