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