Formatting a number in millions to show thousands

[MrFizzy]

I have a report showing sales figures in millions (i.e. 1,450,312). I need to show this in 000s, i.e. 1,450. I know I can add another column and divide the number by 1,000, but this will be awkward on the report I have due to mutiple columns.

Is there a way I can simply format the cells to just show the rounded thousands? It seems like a really simple request, but I can't find it!

Many thanks.

 

[Andrew Poulsom]

Use a format like:

#,##0,

The trailing comma scales by 1000.

 

[cornflakegirl]

Format as #,##0,

 

[MrFizzy]

Excellent! Thanks very much!

 

[gIGoN]

Guys,

I need help to get the other way round.

I have a figure 0.1234 but I want it to be displayed as 123. Please help on how to achieve this by using custom number formats. Tq.

 

[Andrew Poulsom]

Welcome to MrExcel.

Sorry, that's not possible with a number format.

 

[tennisjazz]

Excellent! Thanks very much!

ditto!

 

[Anzek]

Could someone please explain the logic of #,##0, ?
Thanks

 

[Andrew Poulsom]

The trailing comma scales by 1000. It's explained here:

https://support.office.com/en-us/ar...9e6b-92890d7dc48f&ui=en-US&rs=en-US&ad=US#bm2