Forum Discussion
using TEXTJOIN
Can somebody please point out what I'm doing wrong? Im trying to use the join text function but there is a date involved. Every time I add the cell that contains the date, it wants to list it as "43218". I want it to list like this though: 4/28/2018. Anybody have any thoughts on this?
Hi Ronda,
Dates in Excel are actually numbers. Use instead TEXT(A1,"mm/dd/yyyy") if A1 is your date
7 Replies
Hi Ronda,
Dates in Excel are actually numbers. Use instead TEXT(A1,"mm/dd/yyyy") if A1 is your date
OK, one more question, if you don't mind:
I have 57 rows of data and I need to do this =TEXTJOIN(C2,,B2,TEXT(D2,"mm/dd/yyyy"),F2,H2,J2,L2)
for every row. Do I have to enter the formula individually for each row? Isn't there a way to change the formula from =TEXTJOIN(C2,,B2,TEXT(D2,"mm/dd/yyyy"),F2,H2,J2,L2) to =TEXTJOIN(C3,,B3,TEXT(D3,"mm/dd/yyyy"),F3,H3,J3,L3) automatically?
Ronda, if you copy the cell with the formula down references in it will be changed automatically
- TEXT(D2,"mm/dd/yyyy") this works thank you so much
- D2 "mm/dd/yyyy" this tells me invalid
