Format to print space instead of zero

lbImageCounts.cell( i, 1 ) = Format(rsRecall.Field( "M01" ).DoubleValue, "##,###")

I have the above code in a method that populates a listbox. When the value is zero I want to print a space but this code displays a zero.

Have I missed something?

thanks

“##,###;-##,###;” should work
you have 3 fields separated by a “;”
the format if the number is positive, if negative and if zero.

Thanks so much