I have a very large XLS Workbook with a lot of sheets and values. I have been asked to round all dollar value fields to Millions...
in the past In used a format like this #,##0.0,,;;
Only problem is I have some values that are negative and I am showing those in red with parens around them.
what would be the best solution to resolve all my needs