Formatting integers using regional settings
<< Subject: Formatting integers using regional settings
Date: Mon, Dec 9, 2002 2:09 PM
I have to format number without decimal places but using the regional
settings so that I get the correct thousands separator.
In German, 123456 should be displayed as 123.456
In English, 123455 should be displayed as 123,456
If I use the 'System Default Number format', the decimal places are always
included. Eg. In german, 123.456,00
On the other hand, if I select customize and set Decimals to 0, then I dont
get the fractional part but the proper thousands separator is not used.
Is there a way I can get the proper thousands separator without displaying
the decimal digits ?
Thanks in advance,
Arun >>
Okay, here's my quick and dirty way to set up preferences.
1. create a file with one record that has your constant info (Language,
Customer Address, etc)
2. Put a subreport in the report header that reads that file and makes the
information available as a shared variable
3. use that shared variable in a formula to do formatting.
