You can use ither ROUND() ROUNDUP() or ROUNDDOWN() functions. You just
need to enter the Cell number and no of DP you would like.
i.e =round(A1,1) for 1dp.
Thanks
Gazzr
--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile:
http://www.excelforum.com/member.php...o&userid=31075
View this thread:
http://www.excelforum.com/showthread...hreadid=539161