Hi Forum,
Has anyone found that when exporting a report from the viewer and choosing the "Excel Worksheet" option from the format dropdown that all negative values in a report grid are preceded by a single apostrophe (')? I know single apostrophes in excel are used to escape formulas, but the negative sign (-) should not be interpreted as a formula in excel when placed in front of a numeric value so I'm not sure why there would be a need to add apostrophes.
Thanks,
Derek