I have a percentage cell within a matrix. I want this cell to be formatted to 1 decimal place, so I use the format of ##0.#% (After trying P1 etc). The cell appears formatted ok within the report viewer:
100%
12.9%
However after exporting to Excel the following occurs:
100.% - There is no 0 after the decimal point (but there is a decimal point . )
12.9% - Works ok when the the trailing digit is not a 0
Any ideas?
format: ##0.0%
No comments:
Post a Comment