Thread: how do I convert numbers to the nearest 1000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default how do I convert numbers to the nearest 1000
One way is to use MRound:

=Mround(a1,1000)

This requires the Analysis ToolPak to be installed.

Or:

=int(a1/1000)*1000

--
Regards,
Fred


"Brian" wrote in message
...
how do I convert numbers to the nearest 1000


Reply With QuoteReply With Quote