mass changes in formulas

  • Thread starter Thread starter itsmetisa
  • Start date Start date
I

itsmetisa

How do I change all the '2003' in the formulas in my worksheet to
'2004'? I would like to avoid retyping all the formulas.

Thanks - Tisa
 
Hi

When there aren't any '2003's exept those you want to replace (on sheet or
in selected range) then try 'Replace All' (Edit.Replace)
 
itsmetisa said:
How do I change all the '2003' in the formulas in my worksheet to
'2004'? I would like to avoid retyping all the formulas.
Click to expand...

You posted a very similar question in .programming last week,

http://groups.google.com/[email protected]

What was wrong with the answers you got there? Didn't ExcelForum show the
responses? If so, follow up in that thread. If not, reconsider using
ExcelForum.
 
Hi Harlan!!

The responses I got from Programming were fine. I'm new to Excel Forum
and I couldn't find the responses until you posted the URL. Now I'm
understanding better how it works. Thanks for the help...

Tisa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing ref's within formulas without having to retype each one. 3
How do I mass update formulas? 5
Dependent "If" formulas 2
Need to display values instead of formula; Ctrl + ` doesn't work 1
Excel VBA 1
Copy Formulas 1
Locking cells with formula 1
Copied info from Excel worksheet, but pasted info won't work in fo 3

Back
Top