How do I delete a formula from the Formula Bar where I want plain text (mon/yr) in certain cells?

Occasional Visitor

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)

1 Reply

@HamdenNana Select the cell and press back-space. Now just enter the Month Year text preceded with an apostrophe, like this:

Screenshot 2022-09-12 at 06.54.44.png

If this is not what you had in mind, please clarify.