You are probably exporting a CSV file which is just text seperated by commas
and has no formating. To format the sheets you 1st have to perform a SAVEAS
to a XLS filename. Then format the XLS file.

"widman" wrote:

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?