how do I convert numbers to the nearest 1000
 

how do I convert numbers to the nearest 1000

how do I convert numbers to the nearest 1000
 

=round(a1,-3)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=509613

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