Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the date format in Excell from eg 20060926
Excell doesnt recognise the above format as a date, so I would like to change
it, however the standard date formats dont work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the date format in Excell from eg 20060926
use:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) -- Gary's Student "Dave" wrote: Excell doesnt recognise the above format as a date, so I would like to change it, however the standard date formats dont work. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the date format in Excell from eg 20060926
dates eg: 20060926
Another way is to use Data Text to Columns. Select the col of "dates". Click Data Text to Columns, click Next Next. In step 3 of the wiz, under Col data format, check "Date" and select: YMD from the droplist next to it, click Finish. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave" wrote: Excell doesnt recognise the above format as a date, eg: 20060926 so I would like to change it, however the standard date formats dont work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"if" statment in excell cell that will change format in another | Excel Discussion (Misc queries) | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Change the format of my footer {date} option? | Excel Discussion (Misc queries) |