Thread
:
How do I format a number to cut off the thousands?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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??
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann