ExcelBanter - CONCATENATE-1

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

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

- - CONCATENATE-1 (https://www.excelbanter.com/excel-programming/324996-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

All times are GMT +1. The time now is 10:12 AM.