Skip to Content
Former Member
Apr 06, 2016 at 12:23 PM

Number Formatting----Decimal Places in Excel 2010


In Webi report, I have a column named Performance.

It comes from measurement variable.

Formula is =[Sales]/[Target]

I Do Format Cell like below (2 decimal Places)

However, when I save my report as Excel, I get numbers like that.

NumberFormat seems to be missing.

Could any one please help me with this issue...?

My requirement is to show in Excel, the exact same number format with 2 decimal places, like in Webi Report...

Thank you...


Excel.png (13.3 kB)
Webi.png (31.5 kB)