Forum Discussion
How do I delete a formula from the Formula Bar where I want plain text (mon/yr) in certain cells?
Hi, I want plain text to appear in the cells in a certain column ("Mon/Year"). But I've somehow managed to introduce a formula into the bar where I type the month and year. It looks like this: =A20July 2015+A19 I've tried multiple ways to delete the formula, but to no avail. Will be grateful for all suggestions! (I'm using Excel on a Mac)
HamdenNana Select the cell and press back-space. Now just enter the Month Year text preceded with an apostrophe, like this:
If this is not what you had in mind, please clarify.
