MrFizzy
Board Regular
- Joined
- Feb 14, 2008
- Messages
- 59
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.
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.