Hi All,

I could not able to bring a '%' for a computed column values if I try to bring it in a excel format.. I don't remember the code but I will put a little here just for your idea.

  

TABLE FILE CAR

PRINT CAR
COMPUTE TEST/D12.2% = 10 * DEALER_COST;
ON TABLE PCHOLD AS EXL2K
END

In HTML, I can see the '%' coming for all values in a column (TEST) where as in EXCEL it is not.

I don't want to convert from packed decimal to alpha and concate % symbol

Any idea ?

Thanks!

This message has been edited. Last edited by: Kerry,

Hi

This seems to work fine:

TABLE FILE CAR

PRINT CAR
COMPUTE TEST/D12.2% = 10 * DEALER_COST;
ON TABLE PCHOLD FORMAT EXL2K
END

What I have found is that the '%' sign is carried into excel for the report data but not subfoots. My fields were packed so I converted them to alpha using the PTOA() function and it pulled the '%' sign in, but they are now alpha values in the excel spreadsheet.

All data in headings, footings, subheadings and subfootings is in alpha string format. Just append a "%" to the result of the PTOA function.