question re dates

[cart0250]

I have dates imported from an external application in the format:

71205

for december 5th 2007, for example

 

[dave3009]

Hi There

The reason is that 71205 is a unique way of displaying a date

7 for 07, 12 for Dec, 05 for 5th

You'll need some LEFT's and RIGHT's to align them the way you want

 

[cart0250]

ok

 

[dave3009]

Try this on your data

=RIGHT(C7, 2)&"/"&LEFT(RIGHT(C7, 4), 2)&"/0"&LEFT(C7, 1)

And see how you get on

KR


Dave

 

[dave3009]

C7 being the cell with your source data BTW

 

[cart0250]

thanks!

 

[cart0250]

=RIGHT(C7, 2)&"/"&LEFT(RIGHT(C7, 4), 2)&"/0"&LEFT(C7, 1)

 

[cart0250]

would it be:
=LEFT(RIGHT(G3, 4), 2)&"/0"&LEFT(G3, 1)& RIGHT(G3,2)

 

[dave3009]

No I think you may have misunderstood my take on your data

you have

71205 I split this like 7/12/05 and rearranged it to 05/12/07

You now have

70714 which by rights when split up like I first imagined it would be 14/07/07

You data is looking like YMMDD the Rights and Lefts covert it to DD/MM/YY style formatting

HTH


Dave

 

[dave3009]

Actually now I get you, I am formatting UK Style apologies

Yes

=LEFT(RIGHT(C7, 4), 2)&"/"&RIGHT(C7, 2)&"/0"&LEFT(C7, 1)

would be the US MM/DD/YY format

KR


Dave