Point decimal instead of Comma decimal

[ecabanas]

Hi

I have an expression and i want to output to a csv and the sales has to be in point decimal separator .

For example the first row has to be "98.99", the working formula is:

='"'&num(Sum(IMPORTBRUT ),'#.###.##')&'"'

but did not works

[srchilukoori]

You can update this in the Number format tab of the chart.

[swuehl · Accepted solution]

Try

='"'&num(Sum(IMPORTBRUT ),'#,###.##','.',',')&'"'