Hello:

After exporting data to Excel 2007 from my accounting application, the
phrase "#NUM!" appears for cells in the date column where there was never a
date in the cell (i.e. the date in the cell was 0/0/00). And, for cells
where there was "null" data in the accounting app, some strange looking
characters appear.

I'm creating a macro that formats this spreadsheet Is there any sort of
command that I can give to the spreadsheet or button that I can press to
throw out goofy looking cells like this all at once. It's a big spreadsheet.

Also, when I tell the spreadsheet to do subtotals on each change of the
account number, the totals are not in bold. That will make it difficult for
the end user to read. Is there a way to tell Excel to bold the totals in the
spreadsheet all at once?

childofthe1980s