Formatting dates after importing data
 

Hope someone can help...

I have imported a large amount of data from a database application into a
new spreadsheet. There is a column that includes dates of birth in the format
,say, 28.07.1965 How can I format the cells in that column so that they read
in the format 28/7/1965. I have tried formatting the cells and trying
different variations but they dont seem to have any effect on the existing
data. I need to sort the data and the current formatting is not suitable.

Formatting dates after importing data
 

With your data in a1, enter in B1:
=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) and sformat B1 to suit.
--
Gary''s Student - gsnu200777


"Mick B" wrote:

Hope someone can help...

I have imported a large amount of data from a database application into a
new spreadsheet. There is a column that includes dates of birth in the format
,say, 28.07.1965 How can I format the cells in that column so that they read
in the format 28/7/1965. I have tried formatting the cells and trying
different variations but they dont seem to have any effect on the existing
data. I need to sort the data and the current formatting is not suitable.

Formatting dates after importing data
 

Hi,

Select your column of dates then

data|Text to columns
Fixed width
Next
Next
Select Date DMY
Finish

Mike


"Mick B" wrote:

Hope someone can help...

I have imported a large amount of data from a database application into a
new spreadsheet. There is a column that includes dates of birth in the format
,say, 28.07.1965 How can I format the cells in that column so that they read
in the format 28/7/1965. I have tried formatting the cells and trying
different variations but they dont seem to have any effect on the existing
data. I need to sort the data and the current formatting is not suitable.

Formatting dates after importing data
 

Great.

Thanks for your reply, what a time saver- cheers!

"Mike H" wrote:

Hi,

Select your column of dates then

data|Text to columns
Fixed width
Next
Next
Select Date DMY
Finish

Mike


"Mick B" wrote:

Hope someone can help...

I have imported a large amount of data from a database application into a
new spreadsheet. There is a column that includes dates of birth in the format
,say, 28.07.1965 How can I format the cells in that column so that they read
in the format 28/7/1965. I have tried formatting the cells and trying
different variations but they dont seem to have any effect on the existing
data. I need to sort the data and the current formatting is not suitable.

Formatting dates after importing data
 

DataText to ColumnsNextNextColumn Data FormatDateDMY

Format to Custom d/m/yyyy


Gord Dibben MS Excel MVP

On Mon, 7 Apr 2008 05:45:00 -0700, Mick B
wrote:

Great.

Thanks for your reply, what a time saver- cheers!

"Mike H" wrote:

Hi,

Select your column of dates then

data|Text to columns
Fixed width
Next
Next
Select Date DMY
Finish

Mike


"Mick B" wrote:

Hope someone can help...

I have imported a large amount of data from a database application into a
new spreadsheet. There is a column that includes dates of birth in the format
,say, 28.07.1965 How can I format the cells in that column so that they read
in the format 28/7/1965. I have tried formatting the cells and trying
different variations but they dont seem to have any effect on the existing
data. I need to sort the data and the current formatting is not suitable.