Click here to Skip to main content
16,018,264 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,

In Grid View
positive amounts are displaying like this $155.00
negative amounts are displaying like this ($155.00)

I want to display the negative like -$155.00

<asp:BoundField DataField="Price" DataFormatString="{0:c}"
 HeaderText="Price"> 


plz correct me on this.

Thanks & Regards,
Pawan.
Posted
Updated 5-Apr-11 21:09pm

Set HTMLEncoded to false and then use this format string:
{0:$#,##0.00;-$#,##0.00);0}
Should do it!
 
Share this answer
 
Comments
Pawan Kiran 6-Apr-11 3:35am    
Vote of 5 and Thank U.
OriginalGriff 6-Apr-11 3:55am    
You're welcome!
Hernan K. Cabrera 3-May-11 5:08am    
Great...

Can I color the negative value red? How?

Thanks.
Hernan K. Cabrera 3-May-11 5:12am    
I did it in rowdatabound event. Is there a property that I could use to do the coloring?
sharma-anurag 20-Dec-12 9:01am    
thanks for give such a great thing
Uae a TemplateField instead:

http://msdn.microsoft.com/en-us/library/bb288032.aspx[^]

Your code woould then be something like:


XML
<asp:TemplateField HeaderText="Price">
    <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='$<%#
            Bind("Price") %>'>
        </asp:Label>
    </ItemTemplate>
</asp:TemplateField>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900