LinkBack URL
About LinkBacks
Not everyone (me included) can see png images.
Try posting jpg images.
Not everyone (me included) can see png images.
Try posting jpg images.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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?
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