Date Format
 

I have a spreadsheet that contains a list of dates but they are formatted as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be appreciated.

Date Format
 

Use a formula such as this to convert it to a date

=DATE(LEFT(A1, 4), MID(A1, 5, 2), RIGHT(A1, 2))

you can then format the date however you wish using standard XL formats.
--
HTH...

Jim Thomlinson


"readystate" wrote:

I have a spreadsheet that contains a list of dates but they are formatted as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be appreciated.

Date Format
 

Thanks...worked fine.

"Jim Thomlinson" wrote:

Use a formula such as this to convert it to a date

=DATE(LEFT(A1, 4), MID(A1, 5, 2), RIGHT(A1, 2))

you can then format the date however you wish using standard XL formats.
--
HTH...

Jim Thomlinson


"readystate" wrote:

I have a spreadsheet that contains a list of dates but they are formatted as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be appreciated.

Date Format
 

=--TEXT(A1,"0000\/00\/00") and format the cell accordingly.
--
David Biddulph


"readystate" wrote in message
...
I have a spreadsheet that contains a list of dates but they are formatted
as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be
appreciated.

Date Format
 

In place with no formulas..............

DataText to ColumnsNextNextColumn Data FormatYMD and Finish.


Gord Dibben MS Excel MVP

On Wed, 28 Apr 2010 10:42:01 -0700, readystate
wrote:

I have a spreadsheet that contains a list of dates but they are formatted as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be appreciated.