Dates in Excel (XP)

[Guest]

How do I change a date from dd/mm/yy to ccyymmdd

 

[Guest]

hi,

I did not understand what is cc,

but:

Format | Cell | Custom

ccyymmdd

hth
regards from Brazil
Marcelo

"Paysol" escreveu:

 

[Dave Peterson]

Make sure that the cell is really a date (not text that looks like a date).

Format|Cells|Custom
type
yyyymmdd
in that custom box

 

[Dave Peterson]

CC = Century
20 in 2006

hi,

I did not understand what is cc,

but:

Format | Cell | Custom

ccyymmdd

hth
regards from Brazil
Marcelo

"Paysol" escreveu:

 

[Guest]

ohhhh. thanks, Dave

"Dave Peterson" escreveu:

CC = Century
20 in 2006

 

[Guest]

Thanks again Dave
but have notice that the century of 2006 is 21 not 20

regards from Brazil
Marcelo

"Dave Peterson" escreveu:

 

[Dave Peterson]

Ok.

CC=the leftmost 2 digits in the 4 digit year string.

=int(year/100)