Making Formulas Visible

		Microsoft Office Forums > Microsoft Excel > Excel
Making Formulas Visible

FAQ

Thread Tools

Display Modes

12-17-2010, 07:53 AM

thorgal67

Windows XP Making Formulas Visible

Office 2003

Novice

Join Date: Apr 2009

Posts: 8

Thanks Bjorn,

it seems to work fine. However, I found a simpler way that suits my needs.

I added an extra column to the right of my formula, and did a Copy-Paste special (formula). I then added a quote sign ( ' ) in front of the formula and dragged the formula down. this will turn the cell into a "text" field, thus displaying the formula.

Tags

formula

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Font List Not Visible	JonJacobs	PowerPoint	0	07-13-2010 07:12 AM
IF Formulas	mizzamzz	Excel	1	07-08-2010 02:32 AM
text not visible in a number of emails	jbrad	Outlook	0	07-06-2010 03:44 PM
Table formulas	markg2	Word Tables	0	01-15-2010 06:49 AM
No Header Gap visible?	dr_mik	Word	0	11-25-2009 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.