none
FormatNumber does not seem to work well. RRS feed

  • Question

  • Hi,

    I'm trying to use the FormatNumber funciton to format a number with the current culture settings.

    I am currently set to French(Canada), his format number is 123 456,789.

    My expression is set to : =FormatNumber(Fields!ConnectedKVA.Value,1,-2,-2,-2).

    Even if my current regional setting is French(Canada), the returned value is always in En-US format (123,456.789).

    I also tried to change the -2 values for -1 values and the result is the same.

    (for information....)

    TristateTrue

    -1

    True

    TristateFalse

    0

    False

    TristateUseDefault

    -2

    Use the setting from the computer's regional settings.


    Any idea?
    Thanks.
    Wednesday, October 10, 2007 5:29 PM