Change number text to Date format?
 

I have a table, and in column AB there are numbers that are entered as
general text. yyyymmdd is the format that I would like excel to recognize
them in. How can I accomplish this task?
--

Change number text to Date format?
 

--Select the range of dates in col AB which needs to be corrected.
--From menu DataText to Columns will populate the 'Convert Text to Columns
Wizard'
--Hit NextNext will take you to Step 3 of 3 of the Wizard.
--From Column Data format select Date and select the date format in which
your data is (YMD).
--Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer.

If this post helps click Yes
---------------
Jacob Skaria


"Doug" wrote:

I have a table, and in column AB there are numbers that are entered as
general text. yyyymmdd is the format that I would like excel to recognize
them in. How can I accomplish this task?
--

Change number text to Date format?
 

DataText to ColumnsNextNextColumn Data FormatDateYMDFinish.


Gord Dibben MS Excel MVP

On Thu, 30 Jul 2009 07:20:01 -0700, Doug
wrote:

I have a table, and in column AB there are numbers that are entered as
general text. yyyymmdd is the format that I would like excel to recognize
them in. How can I accomplish this task?

Change number text to Date format?
 

Thank you so much!
--
Have a great day!


"Jacob Skaria" wrote:

--Select the range of dates in col AB which needs to be corrected.
--From menu DataText to Columns will populate the 'Convert Text to Columns
Wizard'
--Hit NextNext will take you to Step 3 of 3 of the Wizard.
--From Column Data format select Date and select the date format in which
your data is (YMD).
--Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer.

If this post helps click Yes
---------------
Jacob Skaria


"Doug" wrote:

I have a table, and in column AB there are numbers that are entered as
general text. yyyymmdd is the format that I would like excel to recognize
them in. How can I accomplish this task?
--