Forum Discussion
Excel formatting in a mixed cell
Hello, I'm trying to set up a cell to display "on mm/dd/yy", where the date is pulled from another cell via an index and match function. The cell formula is ="on "&INDEX(...)). However, instead o...
Thank you. That works.
I just need to figure out how to merge it with the Index-Match formula, so I don;t need to point to an alternate cell for the date.
Thanks, again,
JQuinn
Alternatively you may apply to the cell into which INDEX/MATCH returns the date custom format like
Plus is that it still will be a date, not text, with which you may work - compare with our dates, whatever.
Thank you, Sergei.
That would be an elegant solution. However, I can't seem to apply that format to the cell and get the intended response. It still displays as 'on 44034'. (See capture image.)
Do you know if that formatting is restricted to certain versions of Excel? I'm using Excel 2016.
JQuinn
In general it shall work. If I apply custom format to such number
result is
If you apply simple date format to the value returned by formula, is it converted to date form? Hard to say what's wrong without sample file.
