custom number format
 

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

custom number format
 

2007 ButtonExcel OptionsAdvancedEditing optionsUncheck Use System
Separators. Use comma for decimal point.

Same in 2003 under ToolsOptionsInternational


Gord Dibben MS Excel MVP

On Tue, 4 May 2010 10:49:01 -0700, Jake
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