How do you convert an uncoded date (e.g., 20080304) to a date form

T

tenorofchange

After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric
 
B

bosco_yip

tenorofchange said:
After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric
Click to expand...

=--TEXT(LEFT(A1,8),"0000\/00\/00")

Regards
Bosco
 
B

bosco_yip

=--TEXT(LEFT(A422,8),"00-00-00")

Bosco_yip


bosco_yip said:
tenorofchange said:
After importing credit card info from my bank, all I see is
"20080320120000[0:GMT]". I want that to read 03/20/08. How in the world can
I do that efficiently? Please help!

Thank you,
Eric
Click to expand...

=--TEXT(LEFT(A1,8),"0000\/00\/00")

Regards
Bosco
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
How do I convert a text string into a date? 4
How to convert decimal year to date format in excel 2
Access General Date Forced To Have Date And Time 2
How do I convert a date to Monday's date within its week? 7
Date format from numbers to a real date? 1
How to select the date? 4
How do I convert date values to non-date format e.g. 01-06-78? 2

Top