hello warren

use ceiling(number, significance) or if u wanna have the other way
round go for
floor(#, Sig)


--
m_anoob
------------------------------------------------------------------------
m_anoob's Profile: http://www.excelforum.com/member.php...o&userid=19892
View this thread: http://www.excelforum.com/showthread...hreadid=345858