P
Paysol
How do I change a date from dd/mm/yy to ccyymmdd
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marcelo
hi,
I did not understand what is cc,
but:
Format | Cell | Custom
ccyymmdd
hth
regards from Brazil
Marcelo
"Paysol" escreveu:
I did not understand what is cc,
but:
Format | Cell | Custom
ccyymmdd
hth
regards from Brazil
Marcelo
"Paysol" escreveu:
D
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
Format|Cells|Custom
type
yyyymmdd
in that custom box
D
Dave Peterson
CC = Century
20 in 2006
20 in 2006
hi,
I did not understand what is cc,
but:
Format | Cell | Custom
ccyymmdd
hth
regards from Brazil
Marcelo
"Paysol" escreveu:
M
Marcelo
M
Marcelo
Thanks again Dave
but have notice that the century of 2006 is 21 not 20
regards from Brazil
Marcelo
"Dave Peterson" escreveu:
but have notice that the century of 2006 is 21 not 20
regards from Brazil
Marcelo
"Dave Peterson" escreveu:
D
Dave Peterson
Ok.
CC=the leftmost 2 digits in the 4 digit year string.
=int(year/100)
CC=the leftmost 2 digits in the 4 digit year string.
=int(year/100)