Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Concatenate Date FormatPosted 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 FormatPosted by Aladin Akyurek on February 17, 2001 2:41 PM
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.