northeyk
asked on
System Default Number Format
How can I use "System Default Number Format" and specify no decimals when I format a number?
If I select "System Default Number Format" and customize it for no decimals, I lose the thousands separator specified in the Regional Options.
For example, if I use "System Default Number Format", numbers display correctly with two decimals:
999999.99 is displayed as 999,999.99 for English
999999.99 is displayed as 999 999,99 for French
I want to format a number so that:
999999 is displayed as 999,999 for English and
999999 is displayed as 999 999 for French
If I select "System Default Number Format" and customize it for no decimals, I lose the thousands separator specified in the Regional Options.
For example, if I use "System Default Number Format", numbers display correctly with two decimals:
999999.99 is displayed as 999,999.99 for English
999999.99 is displayed as 999 999,99 for French
I want to format a number so that:
999999 is displayed as 999,999 for English and
999999 is displayed as 999 999 for French
ASKER
Sorry - I forgot to mention I'm using an old version of Crystal (8.5).
I havent worked in version 8.5. This works in 10 and XI. May be you might have to write a formula?
Gary
Gary
You're going to need to select a custom number format - the 'system defaul' uses Windows default formats which are largely based on the language and customs of the country you're working in.
If you follow the menu options that Gary gave you, you can customize Crystal so that it will use the default format that you specify. After going through the menus listed, click the 'Number' tab and click the 'Customize' button. You can then set the decimals and separator to anything you want and Crystal will use this value as the default.
frodoman
If you follow the menu options that Gary gave you, you can customize Crystal so that it will use the default format that you specify. After going through the menus listed, click the 'Number' tab and click the 'Customize' button. You can then set the decimals and separator to anything you want and Crystal will use this value as the default.
frodoman
ASKER
This is what I want. If I change the number format (customize), it ignores the Windows default. I am in Canada. I have English and French customers. I want the format to reflect their Windows number format - only with 0 decimals.
>> 'system default' uses Windows default formats which are largely based on the language and customs of the country you're working in.
>> 'system default' uses Windows default formats which are largely based on the language and customs of the country you're working in.
ASKER
If their Windows number format it English (Canada), I want 1234 to display as 1,234
If their Windows number format is French (Canada), I want 1234 to display as 1 234
Windows number formats:
English (Canada) is 123,456,789.00
French (Canada) is 123 456 789,00
If I select "System Default Number Format", I get the correct thousands separator for both, but it gives me two decimals.
If their Windows number format is French (Canada), I want 1234 to display as 1 234
Windows number formats:
English (Canada) is 123,456,789.00
French (Canada) is 123 456 789,00
If I select "System Default Number Format", I get the correct thousands separator for both, but it gives me two decimals.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you dont find the format you want in the available list you can customize to yourr requirement as well
Gary