• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

using find and replace

dear all ,
I want to replace only 0 with 2 in the below formula.

=ROUND($E$247*J250,0)
How can i use find and replace to achieve this

the final outcome should be---
=ROUND($E$247*J250,2)

thanx and rgds
 
Make sure the Find and Replace Options are set to look at Formulas, not values. Then, replace:
,0)
with:
,2)
 
dear luke and narayan,
problem is that it also replaces 0 of J250 and becomes J252. Is there a way so that only 0 is replaced by 2
 
Hi,

If you put correct input for in Find and Replace, it would work perfectly.

Note: ",0)" is changed to ",2)".

regards,
PrasadDN
 
Back
Top