J
JDMocko
How do I convert dates from yyyymmdd120000[0:GMT] to mm/dd/yyyy in Excel 2003?
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.
L
Lori
If the date is in A1 try:
=--TEXT(LEFT(A1,14),"0000-00-00 00\:00\:00")
and format the result in mm/dd/yyyy date format.
=--TEXT(LEFT(A1,14),"0000-00-00 00\:00\:00")
and format the result in mm/dd/yyyy date format.
B
Bob Phillips
=DATE(LEFT(A21,4),MID(A21,5,2),MID(A21,7,2))
and format to the required date format.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
and format to the required date format.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
M
Mike
Format - cell - custom mm/dd/yyyy
A
Arun
u could try using activecell.value=format(activecell.value,mm/dd/yyyy)
or as ur requirement is the normal date format u could just save the value
to a variable declared as date and store it again in the destination cell
regards
nc
or as ur requirement is the normal date format u could just save the value
to a variable declared as date and store it again in the destination cell
regards
nc