Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
niha.736
Starting Member
4 Posts |
Posted - 2012-11-02 : 00:38:40
|
Hi in my report some values are negative , they are showing like(12131).i just want to show them as -12131what could be the best solution for this?actually i have used " #,0;(#,0)" this format for my text box properties. this format is for thousand separator without decimal values.can anybody suggest something?thanks,Niahrika |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-02 : 06:58:34
|
Just remove those two brackets - I usually use this:#,##0;-#,##0;"" The first part before the first semi-colon indicates how positive numbers should be displayed. The second part indicates how negative numbers should be displayed and the third part is for zeros. |
|
|
|
|
|