Copy Paste Formatting??

[Jiptastic]

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:

Please Login or Register  to view this content.

I need to reformat to this

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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?

[AlKey]

41487 = 8/1/2013 You just need to reapply format.

[popipipo]

=TEXT(A2,"yyyy-mm-dd") & " T17:00:00PDT"
Try this one

Or change cel B2 in =A2 with celformaat :
yyyy-mm-dd " T17:00:00PDT"