Prev: Pivot Table Column Totals - XL2003
Next: Copy loses order of Conditional Formatting rules
From: Jake on 4 May 2010 13:49
Can a custom number format be created to format a value such as 9,999,999.25
to format 9 999 999,25? I know the # ### ### works to add spaces but I can't
figure out the decimal and don't want to change regional setting.
Thanks,
Jake
From: Gord Dibben on 4 May 2010 14:30
2007 Button>Excel Options>Advanced>Editing options>Uncheck Use System
Separators. Use comma for decimal point.

Same in 2003 under Tools>Options>International


Gord Dibben MS Excel MVP

On Tue, 4 May 2010 10:49:01 -0700, Jake <Jake(a)discussions.microsoft.com>
wrote:

>Can a custom number format be created to format a value such as 9,999,999.25
>to format 9 999 999,25? I know the # ### ### works to add spaces but I can't
>figure out the decimal and don't want to change regional setting.
>Thanks,
>Jake

 | 
Pages: 1
Prev: Pivot Table Column Totals - XL2003
Next: Copy loses order of Conditional Formatting rules