Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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?



Check out our Excel Resources

Re: Concatenate Date Format

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

Try:

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

Aladin


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.