Display in Thousands

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to convert all my spreadsheets to display in thousands with
commas. Unfortunately, I cannot get the commas to show.

Ex, 10,215,159 as 10,215 instead of 10215

I am using #,;(#,)

Please help - Thanks
 
Hi. Try going to Format, cells, then choose Number and to the right of that,
click zero decimal places and check the box marked 'use 1000 separator (,)'
 
_(* #,###,_);_(* (#,###,);_(* "-"_);_(@_)
_($* #,###,_);_($* (#,###,);_($* "-"_);_(@_)

Change to thousands formatting.

1. Without dollar signs
2. With dollar signs

I figured it out... this is the custom format string which should be used
 
You must log in or register to reply here.

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

Number format 6
Decimal dot to Decimal Comma 3
Excel 2002 : How to set thousand separator at tool bar ? 2
Merging worksheet into MS Word mail merge 6
How to convert , comma to . dot in excel to do the following calculation? 2
XL2007 French Numeric Formats 1
How to Format numbers from percentage points to basis points 1
display to thousand 3

Back
Top