none
How to change parenthesis with minus sign for negative numbers? RRS feed

  • Question

  • Is this possible?

     I have a textbox using the currency format, but we want the negative amounts to display with minus signs, not parenthesis.

    Thanks for advice
    Tuesday, October 4, 2016 10:04 PM

Answers

  • Hi,

    You could try changing the Format property from "Currency" to something like this:

    $0.00;-$0.00

    Hope it helps...


    • Edited by .theDBguy Tuesday, October 4, 2016 10:13 PM
    • Marked as answer by HTHP Tuesday, October 4, 2016 11:15 PM
    Tuesday, October 4, 2016 10:11 PM
  • Hi HTHP,

    For comma you can use the format mentioned below.

    $#,##0.00;-$#,##0.00;

    it will take care of - sign, comma.

    for more information regarding format please visit the link mentioned below.

    Format Property - Number and Currency Data Types

    Specify how data displays by using custom formatting

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by HTHP Wednesday, October 5, 2016 12:32 PM
    Wednesday, October 5, 2016 12:54 AM
    Moderator

All replies

  • Hi,

    You could try changing the Format property from "Currency" to something like this:

    $0.00;-$0.00

    Hope it helps...


    • Edited by .theDBguy Tuesday, October 4, 2016 10:13 PM
    • Marked as answer by HTHP Tuesday, October 4, 2016 11:15 PM
    Tuesday, October 4, 2016 10:11 PM
  • Wow, I didn't know you could change that property like that. Thank you
    Tuesday, October 4, 2016 11:16 PM
  • Now there are no commas when the amount is in the thousands.  How do  you fix  that?

    Tuesday, October 4, 2016 11:20 PM
  • Hi, I'm not in front of a computer now but try adding a comma. Maybe something like: $0,0.00 I'll double-check when I get in front of a computer.
    Tuesday, October 4, 2016 11:39 PM
  • Hi HTHP,

    For comma you can use the format mentioned below.

    $#,##0.00;-$#,##0.00;

    it will take care of - sign, comma.

    for more information regarding format please visit the link mentioned below.

    Format Property - Number and Currency Data Types

    Specify how data displays by using custom formatting

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by HTHP Wednesday, October 5, 2016 12:32 PM
    Wednesday, October 5, 2016 12:54 AM
    Moderator
  • Thanks. I was trying things like $000,000;-$000,000 but wasn't able to get it right. I will look more into these format strings. Its working good now.
    Wednesday, October 5, 2016 12:32 PM
  • Glad to hear you got it sorted out. Good luck!
    Wednesday, October 5, 2016 1:18 PM