Millions displayed as thousands

[Roadmap]

I have 500 records with up to 6 digit numbers in each cell. I would
like to show the numbers in thousands, i.e.,
555,777,000 as 555.8

In formatting the cell, I tried custom #,###, producing 556 and not
555.8 Any suggestions?

Thanks

 

[Roadmap]

I have 500 records with up to 6 digit numbers in each cell.  I would
like to show the numbers in thousands, i.e.,
555,777,000 as 555.8

In formatting the cell, I tried custom #,###, producing 556 and not
555.8   Any suggestions?

Thanks

Cancel my request

I tried #,###.0,

This works for me.