| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in Excel (XP)
How do I change a date from dd/mm/yy to ccyymmdd
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
hi,
I did not understand what is cc, but: Format | Cell | Custom ccyymmdd hth regards from Brazil Marcelo "Paysol" escreveu: How do I change a date from dd/mm/yy to ccyymmdd |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
CC = Century
20 in 2006 Marcelo wrote: hi, I did not understand what is cc, but: Format | Cell | Custom ccyymmdd hth regards from Brazil Marcelo "Paysol" escreveu: How do I change a date from dd/mm/yy to ccyymmdd -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
ohhhh. thanks, Dave
"Dave Peterson" escreveu: CC = Century 20 in 2006 Marcelo wrote: hi, I did not understand what is cc, but: Format | Cell | Custom ccyymmdd hth regards from Brazil Marcelo "Paysol" escreveu: How do I change a date from dd/mm/yy to ccyymmdd -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
Thanks again Dave
but have notice that the century of 2006 is 21 not 20 regards from Brazil Marcelo "Dave Peterson" escreveu: CC = Century 20 in 2006 Marcelo wrote: hi, I did not understand what is cc, but: Format | Cell | Custom ccyymmdd hth regards from Brazil Marcelo "Paysol" escreveu: How do I change a date from dd/mm/yy to ccyymmdd -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
Ok.
CC=the leftmost 2 digits in the 4 digit year string. =int(year/100) Marcelo wrote: Thanks again Dave but have notice that the century of 2006 is 21 not 20 regards from Brazil Marcelo "Dave Peterson" escreveu: CC = Century 20 in 2006 Marcelo wrote: hi, I did not understand what is cc, but: Format | Cell | Custom ccyymmdd hth regards from Brazil Marcelo "Paysol" escreveu: How do I change a date from dd/mm/yy to ccyymmdd -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in Excel (XP)
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 Paysol wrote: How do I change a date from dd/mm/yy to ccyymmdd -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
Hybrid Mode
