Hello
I am trying to use FORMAT property in ACCOUNT dimension to let the user have his own regional settings and by this way select his separators but not the number of digits.
To use them, in my EVDRE formatrange, I use in parameters NUMBERFORMAT=ACCOUNT.FORMAT
There is something I do not understand, everything seems to be well adapted except a case :
- when I put 0 in the format, my figure is displayed without decimal then in excel, the format applied in excel is a number without decimal
- when I put #,##0, the number is applied with the thousand separators
But now when I want to manage decimals with #,##0.00 or 0.00 only, then the generated format is in custom (this is not a problem but it is putting the format
#,###.00 ... which gives me ".80" for the value 0.80 ...
I do not know why it does not config the format with the 0 ... is it a know issue ?
Thanks