MobileRead Forums - View Single Post

da_jane · 06-24-2010, 01:30 AM

I've exported a CSV catalog and opened that in Excel. For the pub date, I have this: 1987-06-14T09:00:00+00:00. How do I convert that to the Month, Day, Year?

06-24-2010, 01:30 AM	#294
da_jane Evangelist Posts: 405 Karma: 692 Join Date: Sep 2006 Device: Samsung Galaxy Note 3 \| Kindle Paperwhite \| iPad Mini	I've exported a CSV catalog and opened that in Excel. For the pub date, I have this: 1987-06-14T09:00:00+00:00. How do I convert that to the Month, Day, Year?