I have several reports that create EXCEL workbooks.
Usually numeric fields are dollar fields, and I give EXCEL a decimal field using this command
xlSheet.Range(Cell).Value := item2."COGS (LCY)";
and it is automatically formatted with a $ and two decimals
The bad news is, he is also formatting this as currency
xlSheet.Range(Cell).Value := item2."Sales (Qty.)";
when I want this field to have no decimal places and no $
Anyone know how to do this?
Thanks Scott Wilson AKA SLOWHANDFAN
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
If x = '@', it will be TEXT
If x = '#,##0.00' it will bedecimal
If x = '0' it will be Integer