Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
Is there a formula that would convert 80521 to a date, 05/21/08?
Or convert a text of 080521 to a date format 05/21/08? thx, k |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
=DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2))
HTH Kostis Vezerides On Jul 3, 5:54 pm, KKay wrote: Is there a formula that would convert 80521 to a date, 05/21/08? Or convert a text of 080521 to a date format 05/21/08? thx, k |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
If all your dates will be on or after the year 2000, try this formula...
=--TEXT(A1,"2000-00-00") Rick "KKay" wrote in message ... Is there a formula that would convert 80521 to a date, 05/21/08? Or convert a text of 080521 to a date format 05/21/08? thx, k |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
You should be consistent, as well as keep the value in this century: =DATE(2000+(--LEFT(A1,1+(LEN(A1)=6))),--MID(A1,2+(LEN(A1)=6),2),--RIGHT(A1,2)) HTH, Bernie MS Excel MVP "vezerid" wrote in message ... =DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2)) HTH Kostis Vezerides On Jul 3, 5:54 pm, KKay wrote: Is there a formula that would convert 80521 to a date, 05/21/08? Or convert a text of 080521 to a date format 05/21/08? thx, k |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
Right on Bernie, thanks for the pointer.
Regards, Kostis On Jul 3, 6:13 pm, "Bernie Deitrick" <deitbe @ consumer dot org wrote: You should be consistent, as well as keep the value in this century: =DATE(2000+(--LEFT(A1,1+(LEN(A1)=6))),--MID(A1,2+(LEN(A1)=6),2),--RIGHT(A1,2)) HTH, Bernie MS Excel MVP "vezerid" wrote in message ... =DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2)) HTH Kostis Vezerides On Jul 3, 5:54 pm, KKay wrote: Is there a formula that would convert 80521 to a date, 05/21/08? Or convert a text of 080521 to a date format 05/21/08? thx, k |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 80521 to 05/21/08
Thanks to all! worked like a charm...and saved me time.
"Rick Rothstein (MVP - VB)" wrote: If all your dates will be on or after the year 2000, try this formula... =--TEXT(A1,"2000-00-00") Rick "KKay" wrote in message ... Is there a formula that would convert 80521 to a date, 05/21/08? Or convert a text of 080521 to a date format 05/21/08? thx, k |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) |