Change number text to Date format?

's Computer Specifications

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?
--

's Computer Specifications

--Select the range of dates in col AB which needs to be corrected.
--From menu Data>Text to Columns will populate the 'Convert Text to Columns
Wizard'
--Hit Next>Next 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?
> --

's Computer Specifications

Data>Text to Columns>Next>Next>Column Data Format>Date>YMD>Finish.

Gord Dibben MS Excel MVP

On Thu, 30 Jul 2009 07:20:01 -0700, Doug <(E-Mail Removed)>
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?

's Computer Specifications

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 Data>Text to Columns will populate the 'Convert Text to Columns
> Wizard'
> --Hit Next>Next 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?
> > --

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change number format to date	=?Utf-8?B?RGFu?=	Microsoft Access Queries	4	9th Mar 2006 07:39 PM
Change number (in text format) to numeric format	=?Utf-8?B?UGFt?=	Microsoft Excel Misc	5	24th Oct 2005 07:45 PM
How do i change numbers in text format to number format?	=?Utf-8?B?R3JlZw==?=	Microsoft Excel New Users	1	14th Dec 2004 05:22 PM
make table query - change number format to text format	Mark	Microsoft Access Queries	1	13th Dec 2003 12:10 AM
Change a date in text format xx.xx.20xx to a recognised date format	concatenator	Microsoft Excel Programming	1	24th Nov 2003 11:33 PM