Simple Question ( I think ). I have a cell set up with the formula "=TODAY()"
in it. I have formatted this cell to look like just the month (i.e. May /
mmmm ) . I then have a series of Concatenate formulaes set up which connects
to tha cell, for example =concatenate("text", C5, "text"), with the cell C5
being the month. Unfortunately the month appears as a serial number not as
the month (i.e May). How could I go about changing this ?