This ##0.###; ; produces good results for the example of 0.5 There are some things to watch for in the display detail event 4D v17
0 as blank 1 as 1 .5 as 0.5 .007 as 0.007 .0007 as 0 <- not blank 10.12345 as 10.123 10.1237 as 10.123 <- rounding Keith - CDI > On Aug 5, 2019, at 9:58 AM, stardata.info via 4D_Tech <[email protected]> > wrote: > > Hi All, > > I need to format one column in a list box. > The column contains numeric values. > The values can have tre decimal digits. > I want a blank if number is zero. > I need to display 0,5 value for examples and i use ##0,00;; as a format but > not work. > > Does someone have a suggestion? > > Thanks > > Ferdinando ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
