using find and replace

[paramnayak]

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

 

[NARAYANK991]

Hi ,

Can you not use 0) as the Find text , and 2) as the Replace text ?

Narayan

 

[Luke M]

Make sure the Find and Replace Options are set to look at Formulas, not values. Then, replace:
,0)
with:
,2)

 

[paramnayak]

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

 

[prasaddn]

Hi,

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

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

regards,
PrasadDN

 

[paramnayak]

yes its working.

sorry , my mistake