Thread: EXCEL: display number in '000s ie £15000 show as £15
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JILL
 
Posts: n/a
Default EXCEL: display number in '000s ie £15000 show as £15
Trying to find function that will take number and round down and show as
multiple of 1000's. ie. £15000 will show as £15. MROUND does not seem to be
the right formula.
Reply With QuoteReply With Quote