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...
Assuming your date is in cell A1, use this ="on "&TEXT(A1,"m/d/y")
Because what you're doing is creating a text entry, you need to turn the date into a text and format it. The TEXT function takes care of that, and one of the arguments is the way you want it displayed. The same sort of thing would apply if you were dealing, say, with financial numbers and wanted it to be in dollars and cents.
