I found that the grid formatting at least with version 6 is pretty limited so I turned to SQL to put the $ in the results of my query. Here is the query:
All you will need is the second line of the query but I thought I would include the whole thing is case it provided any insight.
SELECT ws._ResourceGuid AS 'LicenseGuid',
'$' + convert(varchar(10), convert(money, ws.SoftwareCost)) as 'Total Cost',
ws.SoftwareCost as 'NumericCost',
ws.SoftwareCategory as 'Software Category',
ws.SoftwareFriendlyName as 'Friendly Name',
ws.SoftwareIsSelectable as 'Selectable',
ws.SoftwareAppEmail as 'EMail',
ws.SoftwareCitrixGrp as 'Citrix Group',
ac.Collection as 'Authorized Collections'
FROM Inv_Workflow_SoftwareDataClass ws
LEFT JOIN Inv_Authorized_Collections ac on ws._ResourceGuid = ac._ResourceGuid
WHERE (ws.SoftwareIsSelectable = 'True'
AND ws.SoftwareFriendlyName LIKE @SoftwareSearch
AND (@SelectMachineType = 'Install to PC (above)'
OR @SelectMachineType = Null))
OR (ws.SoftwareIsSelectable = 'True'
AND ws.SoftwareFriendlyName LIKE @SoftwareSearch
AND (@SelectMachineType = 'Install to Thin Device'
OR @SelectMachineType = Null)
AND ws.SoftwareAvailForCitrix = 'True')
ORDER BY ws.SoftwareFriendlyName