Decimal Formatting Zeros 1

[adamroof]

Have data... Fill to DropDown Want This
Decimal(10,3) {0:N}, or nothing; to Display
viewed in SQL Viewed in DDL just like SQL
----------- --------------- -----------
.25 0.25 .25
.75 0.75 .75
1.5 1.50 1.5
2 2.00 2
3 3.00 3
15 15.00 15
155 155.00 155


i just want to view it like if i return all rows in that table in enterprise manager! ive tried all the formatting options i could think of,
{0:c},{0:N2},{0:N},{0:F},{0:G}
any others ive missed?

thanks!

 

[jbenson001]

Try:
{0:#.##}

 

[adamroof]

YAHOOOOOOOOOOOOOOOOOOOO!!!!

 

[jbenson001]

I happend to run into that formatting somewhere in help. The codes you put in are the only ones I saw for the FormatString property. They don't make mention of using the ##. So I figured why not try it, and hey it worked...


Glad to help and I learned something too...
Jim