Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nikolaus
Contributor
Contributor

Format numbers and money with leading +

Hello,

after the update to August 2023 Patch 2 - 14.139.6 I have noticed following difference: With older versions I could use the number format +0,00%;-0,00%; in a straight table. After the update the format still works but the data could not be exported with keeping the format.

Every Excel Export has the size of 9KB and could not be opened "corrupt fileformat"

When I change the format to Auto and change the expression like below, the export works again:

=num( ([Monatsumsatz]-[Monatsumsatz Vorjahr]), '+ #.##0,00 €; - #.##0,00 €; ')

It seems that the problem is related to the € sign.

1. Has anybody else noticed this behavoir?

2. What is the best way to get a leading + for numbers, money?

Thanks

Niko

 

Labels (1)
0 Replies