Hi
I agree with Vasat (your example does not match your description) but
you may have a look at the ROUND function. Especially if you have
formulas in your cells.
You may also consider formating them to just display only thousands.

So please restate your problem and it should be easy to provide an
answer to you


--
Regards
Frank Kabel
Frankfurt, Germany


Please help!!!

I have six sheets in one workbook that requires cells containing
links
to be converted to whole values that are have been rounded to the
nearest thousand..

eg. 150,006,52300.04 should be rounded to 150,007.

The sheets contain text too , and the numbers are from links to other
work books.

Basically I would like a VBA script that can be run on a sheet to
convert the linked values to numbers rounded to the thousandth value.

Thanking you in advance.

Kiran Harry.

please use work email address:




---
Message posted from http://www.ExcelForum.com/