View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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??