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