Thanks,
-Jim Epler
Grossmont Union High School District
El Cajon, CA
http://edtech.guhsd.net/
a formula
=right(a2,4)&left(a2,4)
--
Don Guillett
SalesAid Software
dguil...@austin.rr.com
"jim" <jim....@gmail.com> wrote in message
news:1148682170.6...@u72g2000cwu.googlegroups.com...
=DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2))
(assuming date is in cell B2)
Then you could use whatever format you want for the date via menu item
Format | Cells.
-Jim
--
Don Guillett
SalesAid Software
dguil...@austin.rr.com
"jim" <jim....@gmail.com> wrote in message
news:1149090041....@i39g2000cwa.googlegroups.com...