How to change parenthesis with minus sign for negative numbers?

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

Answer 1

Hi,

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

$0.00;-$0.00

Hope it helps...

Answer 2

Wow, I didn't know you could change that property like that. Thank you

Answer 3

Now there are no commas when the amount is in the thousands.  How do  you fix  that?

Answer 4

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.

Answer 5

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.

Answer 6

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.

Answer 7

Glad to hear you got it sorted out. Good luck!