Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home



converting a date to text

Posted by Randy on August 28, 2001 11:44 AM
I need to convert a "date" to a text time value. The imported file date format is "8/23/2001 13:00" in a date format. I need to convert this value to a text 1300.

Re: converting a date to text

Posted by Mark W. on August 28, 2001 11:56 AM
=TEXT(A1+0,"hhmm") where cell A1 contains the
text representation of your datetime value.


Actually, =TEXT(A11,"hhmm") will suffice (NT)

Posted by Mark W. on August 28, 2001 11:57 AM




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.