Fix Custom Formatting of "#,0.#" on export to Excel

[BrianMRogers]

In my report, I'm attempting to take a column and format values such as
7.5,

10,

11.5,

177,

226,

9,020.5.

I'd like to only show the floating point values when they are present.

The issue is, the formatting of "#,0.#" will display the correct format for these numbers in my visual, but when exported to Excel, there is a trailing "." to all of the whole numbers, like so:

7.5,

10.0,

11.5,

177.0

226.0

9,020.5.

My current workaround has been to format these numbers as a text column, but that will cause the values to become left-justified, which isn't the standard for numeric values.

Please let me know if there is something I can do, or if this is a bug that could be fixed.

Thanks,

Brian

[Anonymous]

Hi @BrianMRogers 

What do the results look like in the correct format you're talking about? Can you provide the corresponding screenshot. Also, what version of Desktop are you using for testing?

Best Regards,
Community Support Team _ Ailsa Tao