Format Excel column as percent

[rdevivo]

I have successfully formatted my Excel columns as dates or currency using the GetDataParams event, but I can't figure out how to format a column as a percent (i.e., multiply by 100 and add % symbol). I don't want to format the column as text since I want to retain the underlying number for calculations.

Is there any FormatText string I can use to achieve this?

[nancy]

Hi rdevivo,

About your problem, I have writed a demo in the attachment. You can refer to it. Thank you for your cooperation and understanding.