How do I format a number to cut off the thousands?
I need to format an entire set of financials to reflect all numbers rounded
to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas?? |
How do I format a number to cut off the thousands?
Liz.
Try a Custom format of: #,###, -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Liz" wrote in message ... I need to format an entire set of financials to reflect all numbers rounded to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas?? |
All times are GMT +1. The time now is 07:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com