C# Excel Percentages Converted to Decimals

Question

I am reading data from an Excel worksheet. Some of the data is percent values and these values get converted to decimals automatically -- ie 90% --> 0.90. I can't seem to find anyway to keep this from happening. Also, aren't all the data on the Excel sheet strings? So why would number formatting be happening at all?

Any advice is appreciated.

Regards.

Answer 1

Percentage is a formatting artifact in Excel. The actual number is always a decimal fraction (0.9 in your case). Percentage is only a way to display your number on the worksheet.

If you know that a column represents percentage, you should multiply it by 100.