=ROUND(A1,-3)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"walt" wrote in message
...
I have a permit formula that needs to have any input numbers rounded to the
nearest 1000

Thanks

PS sorry for the last post hit the enter key to fast