custom number format

J

Jake

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom inputs 1
Assign custom number format to the ribbon 0
Custom Number Format for text 8
Custom number format 4
2007: Number format <> Number format 1
Decimal Symbol - point needed 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
For Joey2004 et al. From OP: Re Appending Question 3

Top