Good Morning group,
I am having a issue with custom formatting see below. Each month I bring a csv file inn with 500-600 items I have created a template to import it to however i need the date format changed as described below. Any HELP is greatly appreciated.
Thanks
What I would like to have is "YYYY-MM-DDThh:mm:ss-GMT" or the actually to show this: 2014-01-06T00:00:00-05:00,
however when I apply it to the cells with the date in it I get this:"2013-01-10T00:00:00-1T". I am applying it to a cell that has "10-Jan-13" in it.
Bookmarks