Number-Format
Hi,
I tried to format a value using
"[kmEnde #N#,##0.0] km"
but FR 2.51 prints something like
"1.234.0 km" instead of "1.234,0 km".
As I have a "," set as the decimal seperator, FR simply seems to ignore it. On the other hand, if FR wouldn't be able to deal with non-us-formats, I'd expect something like
"1,234.0 km"
but "1.234.0 km" seems to be a mixture of both...
So - how can I format a string the way I need to? Is it necessary to write a user defined function for FR in order to get properly formatted strings?
Kind regards,
Mark
I tried to format a value using
"[kmEnde #N#,##0.0] km"
but FR 2.51 prints something like
"1.234.0 km" instead of "1.234,0 km".
As I have a "," set as the decimal seperator, FR simply seems to ignore it. On the other hand, if FR wouldn't be able to deal with non-us-formats, I'd expect something like
"1,234.0 km"
but "1.234.0 km" seems to be a mixture of both...
So - how can I format a string the way I need to? Is it necessary to write a user defined function for FR in order to get properly formatted strings?
Kind regards,
Mark
Comments
first you can set display format for memo object to number and select separator and number of decimals. the memo could then contain
[var or field] km
since memos can contain both variables and static text.
or build your format string correctly and contain it within ' ' when using the format function.
regards