Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h

[Guest]

i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006.

nOT SURE HOW TO DO IT THANKS

ADAM

 

[Guest]

Hi Adam,

The only way I have been able to do this is by separating the input of the
day, month and year data with hyphens ( - ) or backslashes ( / ) and changing
the cell format thus: Format => Cells => Custom => Type dd mmmm yyyy.

HTH

Ewan

 

[Guest]

Sorry,

Should read dd mmm yyyy.

Ewan

Hi Adam,

The only way I have been able to do this is by separating the input of the
day, month and year data with hyphens ( - ) or backslashes ( / ) and changing
the cell format thus: Format => Cells => Custom => Type dd mmmm yyyy.

HTH

Ewan

 

[Guest]

THANKS EWAN SEEMS A LITTLE STRANGE THAT EXCELL CAN'T DO THIS

 

[Niek Otten]

=DATE(RIGHT(A1,2)+2000,LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2))

But depending on what position you assume the month to be, you might have to
switch 2nd and 3rd argument. It is now set op so that 60306 means 3rd of
June 2006

 

[Guest]

THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL

 

[Guest]

THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL

 

[Guest]

THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL

 

[Guest]

THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL

 

[Guest]

THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL

 

[Dav]

use what nick said and format dd-mmm-yy this will make it 28-DEC-06. T
make it the 28th DEC 06 can be done but is not worth the effort!

regards


Da

 

[Niek Otten]

=DATE(RIGHT(A1,2)+2000,MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4))

 

[Guest]

THANK YOU GUYS

=DATE(RIGHT(A1,2)+2000,MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4))