Convert DateTime true value to text.

Microsoft Microsoft excel 2007 open lice...
August 24, 2011 at 08:46:25
Specs: Windows XP
Information in cell 07-04-2010 8:11:22 PM and the cell is formatted yyyy-mm-dd H:mm:ss so the visible value is 2010-04-04 20:11:22. I want the visible value to be a text value in the cell. Data is imported from Oracle DB (that I have no control of) using a SQL statement (that I control). Data comes in as standard DateTime.

See More: Convert DateTime true value to text.

August 24, 2011 at 10:56:37
=TEXT(A1, "yyyy-mm-dd H:mm:ss")


Format will be General

Format it as Text

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question