Problem when exporting data into Excel sheet!

hazemhazem Member Posts: 187
I have to export data displayed in a form into Excel. When i export decimal filed, "euro symbol" is automatically displayed but that's not what i need; i want to display %. For example if i export 12.54 into excel i have 12.54 "euro symbol" and what i want to have is 12.54%. How to do this?


  • PellePelle Member Posts: 18
    Excel is too "intelligent" and guesses wildly.

    Try to set the cell format first.


    Worksheet.Range('D'+FORMAT(i)).NumberFormat := '0.00%';

Sign In or Register to comment.