Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
converting a date to textPosted 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 textPosted 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.