Hi,

I have to compare a very large worksheet, some of the numbers are only
acurate to 3 decimal places, some of the others are accurate to about
10 d.p.

I need to somehow shorten the numbers that are 10 dp down to 3 dp so
they will compare properly. If I go into format cells and adjust the
settings there all this does is shorten the amount of numbers shown on
the worksheet, the full number is still in the background and as such
the MATCH formula returns a false.

Any ideas would be greatly appreciated.

Regards,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=529643