negative number format

[daniel]

Hi,

I'm trying to set the number format in the Cube Views for negative numbers with gaps instead of a minus.

The User culture is in Spanish because I need the decimals with the comma.

I don't find how can I customize the format for that because N1 is not an option because the negative numbers appear with a minus.

Thanks,

[T_Kress]

In your cube view you can take one of the standard number formats and edit it as I did here:

NumberFormat = [#,###,0;     #,###,0;0]

I went here to do so and it worked:

[daniel]

Yes, but the thing is that it works for English culture, but for Spanish culture (with the European number format) it doesn't work

[KarlT]

I don't see why it would only work for English culture. i just tested with French culture on my machine and it worked as i would expect.

[daniel]

And how could you get the number format like this:

3.333.333,25

(3.333.333,25)