Display in Thousands

M

MorningMuse

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
 
K

Karina

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 (,)'
 
M

MorningMuse

_(* #,###,_);_(* (#,###,);_(* "-"_);_(@_)
_($* #,###,_);_($* (#,###,);_($* "-"_);_(@_)

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
 
Top