I'm trying to figure out how to maintain the date format when I concatenate a date formatted cell with a nondate formatted cell. Result: The Date Format Is LostFormulas UsedDesired Result: I had to convert Date format to Text OnlyI'm trying to figure out how to maintain the Date Format while combining two cell values. Any ideas?
Date Format Lost When Combining Two Cells Using & and CONCATENATE in Google Sheets
google spreadsheets;formulas;date;concatenate
You can do the formatting on the fly:=text(B2,m/d/yyyy)&C2Google Sheets Help: TEXT()