Round function question
Posted by Hansoh on February 15, 2002 12:08 PM
i send templates out to different groups and they return them to me with formulas filled out in these templates.
i need to upload these values into a financial reporting system. however, the outside system does not accept values with decimal #s.
i ask the people who submit these templates to either use the ROUND function in their formulas or submit values (NOT formulas).
basically, i need to apply the ROUND function to all these formulas. it's kind of a pain in the ass to do FIND/REPLACE 'round()' OR cut paste special values then round OR (God forbid) manually round.
what is the MOST efficient and MOST elegant method to apply the ROUND function to a motley worksheet? is there some trick that you know of? please advise.