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

Excel does not accept text format! 0
How to Create an S-Curve from Custom Field? 0
Custom Number sequences 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Publisher 2019 Format Picture window size too large to display OK button 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
How to count the numbers in a Word document? 0
Adding sequence numbers to paragraphs 0

Top