Perhaps I'm feeling a bit grouchy today, but ...

When you post a question here, it would be good etiquette to make sure that
your problem us clearly stated and that there there is no confusion.

In a couple of places, you say the nearst thousand." Elsewhere, you say "the
nearest thousandth." Your example seems to round to the nearest hundred
thousand.

You can't expect people to spend time trying to read your mind! :)

--

Vasant



"kiranx " wrote in message
...
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/