i need to chand a value
 

i have everything in my excell document dating through weeks and i want it in
months, e.g 52 (weeks) 78, 104, 130 . Is it possible to do like an IF
function, were if its 52, its changed to 12, 18, 24, 30?

e.g. of actuall text

dry1052 (i need to change the 52 part) and i have like 300 of these types
of values i need to change, or i would just manually do it

Find/Replace won't work for you?
*******************
~Anne Troy

www.OfficeArticles.com


"Remote help" <Remote wrote in message
...
i have everything in my excell document dating through weeks and i want it
in
months, e.g 52 (weeks) 78, 104, 130 . Is it possible to do like an IF
function, were if its 52, its changed to 12, 18, 24, 30?

e.g. of actuall text

dry1052 (i need to change the 52 part) and i have like 300 of these types
of values i need to change, or i would just manually do it