Formatting Dates from Text to Numbers

June 04th, 2010 - 09:41 am ET by Tommy | Report spam
I receive data daily with dates in the following formats: dd/mm/yyyy,
d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
numbers.

Regardless I use text to columns, to separate the values into three columns.
Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the
date in one field. Does anyone have any suggestions as to how to do this
better or faster?

Thanks,

Tommy
email Follow the discussionReplies 2 repliesReplies Make a reply

Similar topics

Replies

#1 Jackpot
June 04th, 2010 - 09:45 am ET | Report spam
You can use the Text to Columns Wizard to convert the dates


Wizard'.


your data is ('DMY')

of your computer.



"Tommy" wrote:

I receive data daily with dates in the following formats: dd/mm/yyyy,
d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
numbers.

Regardless I use text to columns, to separate the values into three columns.
Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the
date in one field. Does anyone have any suggestions as to how to do this
better or faster?

Thanks,

Tommy
Replies Reply to this message
#2 Jackpot
June 04th, 2010 - 09:53 am ET | Report spam
Suppose you have selected a column with dates...in Step 2 dont select any
delimiters...or from Step1 select that as Fixed Width..

"Jackpot" wrote:

You can use the Text to Columns Wizard to convert the dates


Wizard'.


your data is ('DMY')

of your computer.



"Tommy" wrote:

> I receive data daily with dates in the following formats: dd/mm/yyyy,
> d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs.
> numbers.
>
> Regardless I use text to columns, to separate the values into three columns.
> Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the
> date in one field. Does anyone have any suggestions as to how to do this
> better or faster?
>
> Thanks,
>
> Tommy
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search