Try this:
Select the whole sheet (CTRL + A) and use the "Find & Replace" (CTRL +
H) command. In the "Find" field, key in ROUND and leave the "Replace"
field blank and click on "Replace All"
*VERY IMPORTANT!
-When doing this, make sure that the sheet only has the ROUND function.
If it also has ROUNDUP and/or ROUNDDOWN, make sure they are "Replaced"
first before you get rid of ROUND to avoid any complications.
hope this helps :)
--
teelim
------------------------------------------------------------------------
teelim's Profile:
http://www.excelforum.com/member.php...o&userid=36856
View this thread:
http://www.excelforum.com/showthread...hreadid=566103