Skip to main content
Solved

How to retain percentage format when exporting ARM report to Excel

  • November 1, 2022
  • 4 replies
  • 236 views

kristianharianja
Semi-Pro I
Forum|alt.badge.img+3

Report:

 

 

Exported to Excel:

 

I currently use P as format in column set.

Best answer by Laura03

Hello,

Did you try 0.##%?

What options did you try? 

4 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 1, 2022

Hello @kristianharianja ,

I did a test and the % stays formatted in this report, when exported to Excel:

The Column Set looks like this:

Row Set has no formatting:

Hope this helps you.


kristianharianja
Semi-Pro I
Forum|alt.badge.img+3

Thanks @laura01 that works however when the percentage value below 1% the leading zero is missing. What's format to also retain the leading zero?

 


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • November 19, 2022

Hello,

Did you try 0.##%?

What options did you try? 


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 19, 2022

Hello @kristianharianja ,

Did my suggestions above work out for you?  If not please let us know so we can assist.  Thank you!