| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h
i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006.
nOT SURE HOW TO DO IT THANKS ADAM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h
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 "Adam" wrote: i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
Sorry,
Should read dd mmm yyyy. Ewan "ewan7279" wrote: 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 "Adam" wrote: i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
THANKS EWAN SEEMS A LITTLE STRANGE THAT EXCELL CAN'T DO THIS
"ewan7279" wrote: Sorry, Should read dd mmm yyyy. Ewan "ewan7279" wrote: 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 "Adam" wrote: i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h
=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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it please h
use what nick said and format dd-mmm-yy this will make it 28-DEC-06. To make it the 28th DEC 06 can be done but is not worth the effort! regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=519298 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
=DATE(RIGHT(A1,2)+2000,MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4))
-- Kind regards, Niek Otten "Adam" wrote in message ... 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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turn 10106 in to 1st of JAN 2006, date wise I can't do it plea
THANK YOU GUYS
"Niek Otten" wrote: =DATE(RIGHT(A1,2)+2000,MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4)) -- Kind regards, Niek Otten "Adam" wrote in message ... 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 "Niek Otten" wrote: =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 -- Kind regards, Niek Otten "Adam" wrote in message ... i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006. nOT SURE HOW TO DO IT THANKS ADAM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
| Automatic Date Update | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Date Calculations | Excel Worksheet Functions | |||
Linear Mode
