Robert, Don, Bruce, Roberts solution worked. The others I'm afraid did not.
Thanks for your help! Gerard 2014-01-27 Robert Pollard <[email protected]>: > Gerard > > I think you would need to store the value in an A9 format field, as the > Format Defaults for Decimal Point Character: > and Thousands Separator Character are defined for the entire database - via > Shift-F9 > > Here's a formula that seems to work > > if P1F1 > 1.000 > then > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "." ; 1 ] "," > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; ".," ; 2 ] "." > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 2 ] > else > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 1 ] "." > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 2 ] > endif > > > Robert Pollard > Information Ecologist > plus.google.com/+RobertPollardNYC > facebook.com/robert.pollard > @climatechange3 > [email protected] > 1.212.864.3156 > > > On Mon, Jan 27, 2014 at 2:32 PM, Gerard van Loenhout > <[email protected]> wrote: >> >> Good day / evening, >> >> Does anyone know how to change the comma/point in numbers around? >> >> I use in fields the European decimals: HZZ.ZZ9,99 >> (Comma for decimals) >> >> But there are reports in which I want to make swith them around. >> (Point for decimals) >> >> What formula would I use? >> >> Regards, >> Gerard >> >> >> _______________________________________________ >> Dataperf mailing list >> [email protected] >> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf >> > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
