LinkBack URL
About LinkBacks
Here they are as jpg.
formulas 1.jpg
formulas 3.jpg
Here they are as jpg.
formulas 1.jpg
formulas 3.jpg
If you're using Excel 2013 it has a new function called FORMULATEXT.
It does just what its name implies, it returns a formula as a TEXT sting.
If cell A1 contains a formula enter this formula in say, B1:
=FORMULATEXT(A1)
Would that work for you?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Not exactly.
This is for a regulated environment and the formulas in the cell need to be reviewed and verified. This is typically done by printing the workbook then displaying the formulas and re-printing the workbook.
Adding another formula (formulatext) would add another formula to be checked along with the original formula.
Maybe this...
http://spreadsheetpage.com/index.php...t_of_formulas/
that's very interesting but when reviewing that requires me to flip back and forth between 2 worksheets.
Another option do a find and replace
Find =
replace with '=
that converts all your formulas to text and they will not alter to show the workbook after that.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks