Excel Export show 2 decimal places when they are .00
I’ve created an excel spreadsheet that is exported from my app, and it looks great with one exception. I have 2 columns that store decimals. I’ve created a style for them (see below) that specifies to show 2 decimal places. However, if the value is an exact number for example ‘11’, it doesn’t show them on the report as 11.00, it shows them as 11. which makes it look ugly. Could someone tell me a way to make values with no decimal places show .00 after them?
I suppose the problem is with Excel, in your Excel
select the column and click on format cells and then
select Number and in Decimal Places dropdown as 2.