There is a contradiction between your two messages: >> the format ###.##0,##0 > the value: 0,85 That format cannot display those digits for that value. If you’re using a non-English system, the best you can expect is to see is 0,850 In either case, this isn’t a “zero value” unless you’re talking about an individual digit, in which case, you already know to use “#”, not “0”. Thirdly, if there is no typo, this is an unusual numerical format to have two placeholding zeroes. Check two things: which language standard is your system using to format numbers, and which language standard is 4D using to format numbers?
Roger > On Oct 4, 2017, at 08:15, stardata.info via 4D_Tech <[email protected]> > wrote: > > Hi Jeremy, > > I know this and i try, but not work. > This format not display the value: 0,85 > > Thanks > /Ferdinando/ > > Message: 5 > Date: Tue, 03 Oct 2017 18:28:36 -0400 > From: Jeremy French<[email protected]> > To: 4D iNUG Technical<[email protected]> > Subject: Re: Number format > Message-ID:<[email protected]> > Content-Type: text/plain; charset=utf-8 > > The pattern to control the display of a zero value has 3-parts, separated by > a semicolon. Note the 2-semicolons: > > positive_format;negative_format;zero_format > > To display nothing for a zero value, put nothing after the second semi-colon. > > So this display filter will show positive and negative numbers, but display > nothing for a zero value when the object doesn’t have focus: > > ###,##0;-###,##0; > > > >> On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech<[email protected]> >> wrote: >> >> In one listbox, i need to display a number format so if the value is zero >> not display anything. >> I try to insert the format ###.##0,##0 but not work properly. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
