ExcelBanter - CONCATENATE 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CONCATENATE 1 (https://www.excelbanter.com/excel-programming/324994-concatenate-1-a.html)

AYPCN

CONCATENATE 1

J5
HFUP,

K5
031005

L5
=CONCATENATE(J5,K5)
HFUP,38421 how can i get this date corrected to show what is in K5 tryed
formating cell to mmddyy

thanx

Gap

CONCATENATE 1

=CONCATENATE(J5,MONTH(K5),"/",DAY(K5),"/",YEAR(K5))

All times are GMT +1. The time now is 09:22 PM.