Sep 11 2022 08:47 PM
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)
Sep 11 2022 09:57 PM
@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.