View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
teelim teelim is offline
external usenet poster
 
Posts: 1
Default How do your remove ROUND function?


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