I was keep receiving this issue/ticket from my client that as they export numeric dataset to excel sheet from Webi, They are keep getting same formatting errors.
Problem: As I export report from webi to excel value convert into text. I was told use =ToNumber ([Measure]) formula but all the values that are "0.00" or Null are now converting into text in MS 2013. I get green triangle error on excel
everything else seems to be taken as a number. my value is a [measure] object
Solution:
Use this formula.
=ToNumber(If(Isnull([measure]); 0 ; ([measure]).
That should resolve an issue.
-Arsalan Siddiqui
Please check 3386868 for the error
https://scn.sap.com/thread/3386868_
Note: =FormatNumber() formula may not work in this case, Please check 3312221 for =FormatNumber()
http://scn.sap.com/thread/3312221