Post reply

Formatting currency number

  • May 17, 2006 at 12:05 pm

    #172702

    Hi all.

    I want to format a currency number to get the numbers like this:

    1.235,00 €

    I want to see nothing when the value is zero.

    I'm using: #,###.## €  but it's wrong.

    Some ideas?

     

  • May 18, 2006 at 6:39 am

    #638689

    Extend the format mask so that it reads:

     #,###.## €;-#,###.## €;''

    or this if the number will never be negative or you don't care about what it looks like if it is negative:

     #,###.## €;;''

    the important part is the last three characters in the mask (semicolon and two single quotes) which indicate what to do with zero values.  In a format mask, there are 3 possible segments separated with a semicolon delimiter - the foramt to be used for positive numbers, format for negative numbers, and format when zero.

    Maddog    


    maddog

  • May 18, 2006 at 8:33 am

    #638751

    Thank you very much.

    It works fine.

    Ramon

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply