Millions displayed as thousands

R

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
 
R

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
Click to expand...

Cancel my request

I tried #,###.0,

This works for me.
 
Top