June 02, 2008, 03:13 PM
Rob M.Excel not formatting my data with $ signs and commas
When my report runs and outputs in Excel 2k format my first SUM value is not formatting with a $ sign and commas, even though I have it set to format as P12.2CM. Is there any way to force this first sum column to have a $ sign and commas?
0 - 29 Days Old
ACCOUNT NAME TOTALCOST EXPECTED COSTS
XXXXXXX 39130.5 $27,782.66
SUM
TOTALCOST/P12.2CM
COMPUTE EXPECTCOST/P12.2CM = xxxxxxxxxxxxxxxxxxxx
June 02, 2008, 03:27 PM
Rob M.Solved it by doing this:
SUM
COMPUTE TOTALCOST2/P12.2CM = TOTALCOST
COMPUTE EXPECTCOST/P12.2CM = xxxxxxxxxxxxxxxxxxxxx