I have alot of dates that I need to reformat for uploading to a website (Salesforce). I need to take the date and add the time 5PM. They look like this:

8-1-2013
I need to reformat to this

2013-08-01 T17:00:00PDT
I was able to get the first date part by going to custom format and typing YYYY-MM-DD.

Then I thought I could go into the adjacent cell (say B2) and type =A2 & "T17:00:00PDT"

But the adjacent cell will reformat the date back into this crappy number
41487
I need it to read the date as text but I can't format as text or the formula won't work. Is there a way to copy and paste formatting so that a formula will keep the format?