How about String(number;"|yourPreferredFormat") and set it right justified?
Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Resurrecting a question for which I haven't seen an answer: > >If I choose the built-in format "###,##0.00 ;###,##0.00CR" >Forms, list boxes and quick reports look like: > 123.45| >123.45CR| >(difficult to model with proportional font - trying to show positive and >negative both all the way to the right) > >I want: >123.45 | << spaces after positive number >123.45CR| > >That is, decimals aligned. Why is the blank space in the positive section of >the format definition ignored? > >I've gone way over the allowed (time spent tinkering) / (perceived benefit) >ratio on this! >Have tried "#,##0.00"+Char(32)+Char(32)+";#,##0.00CR" with OBJECT SET FORMAT, >also Char(202) > >I verify that this worked correctly in a previous life (4D 6.7, Windows). >Currently 4D 15.4, Mac OS 10.12.4 > >Thanks, >Malcolm > > ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************