MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Concatenate Date Format

Posted by John R on February 17, 2001 2:24 PM

I am trying to use concatenate to have a cell read for example 'Date:
15/01/01' where the date is taken from cell G3 which reads 15/01/01 using
=CONCATENATE("Date: ",G3) but instead of the date appearing I am getting the
date code number. The cell reads 'Date: 36906'. How can I get the date
rather than the code number to appear?

Posted by Aladin Akyurek on February 17, 2001 2:41 PM


=CONCATENATE("Date: ",TEXT(G3,"dd/mm/yy"))