Displaying cell formulas in certain cells only

E

E Edgington

I have a spreadsheet with many formulas that I want to
display, so I checked the Windows Options - Formulas
checkbox. Unfortunately, I have a date column in the
spreadsheet that now displays as a number.

Is there a way to force only certain cells to show their
formulas?
 
A

Alan

One way, highlight the cells containing formulas you want to display,
Edit > Replace
Replace What =
Replace With '=
Replace All > OK
Regards,
Alan.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Display weeks from a Milestone 0
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Create form with checkbox les that expand and collapse sections of the form? 0
Creating a Chart on form from selected data in query. 0
Display next available number 1

Top