MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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.

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.

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

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