How to read the trailing zero from Excel

Question

I am reading data from an Excel sheet as test data,

• Two numbers I need to read are 17.50 and 52.50
• I have configured under Format Cells -> Custom to have 17.50 and 52.50 displayed instead of 17.5 and 52.5

But when I read the two cells, I got 17.5 and 52.5 respectively.

Anyone has a solution?

Answer 1

If all your needing to do is display 17.5, as 17.50 and are always expecting 2 decimal places, you can do the following:

excelValue.ToString("#.00", CultureInfo.InvariantCulture);