ASP.NET, SQL Server, WPF, C#, VB.NET

Paul, 
 
Formatting the field with... 
 
$ #.00;-$ #.00,"" 
 
should do it. 
 
A format can have 4 arguments... seperated by ";" 
 
Section Description... 
 
First The format for positive numbers. 
 
Second The format for negative numbers. 
 
Third The format for zero values. 
 
Fourth The format for Null values. 
 
-- 
 
hth 
 
Al Camp 
 
Candia Computer Consulting - Candia NH 
 
http://home.comcast.net/~cccsolutions 
 
"Paul Burdett" <paul@burdettp.freeserve.co.uk> wrote in message 
 
news:OCcHtyIkGHA.1600@TK2MSFTNGP04.phx.gbl...

Hi Guys 
 
I am populating a listbox from a table using an SQL statement. 
 
One column is currency. 
 
I want to show zero values as blank, not zero. I want to show none blank as 
 
usual currency format. 
 
Is there a format command I can use? 
 
Thanks in advance. 
 
Paul