Please help!!!

I have six sheets in one workbook that requires cells containing link
to be converted to whole values that are have been rounded to th
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 othe
work books.

Basically I would like a VBA script that can be run on a sheet t
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