I need a specific column in my spreadsheet to show the formula and not the resulting value. It still needs to be seen by Excel as a formula but it just needs to show the formula in the cell and not the value. That means I can't convert the cell format to Text as Excel then doesn't see it as a formula. I also need this only for 1 column so toggling between showing formulas and showing results / values isn't an option either. So, as an example:

Cell B3 = 11/11/13 (a short date) In cell F5 I put in =B3 and thus cell F5 shows 11/11/13.

I want cell F5 to show =B3 but I have other cells that use the result in F5 so it can't be a Text format.

How do i do this (preferably not with VB code but I'll take it if that's the only way to do it)

`FORMULATEXT`

superuser.com/a/1416126/579892