Attempting to copy date from one sheet to another

I have been attempting to copy a date & time with a specific format from one sheet to another and add " before and after it in the same field. This is being done to create a specific csv format for date.

The Formula I am using on sheet3 is - =IF(Sheet1!A3="","",Sheet2!I3&Sheet1!G3&Sheet2!I3)

The Values I am using are below
Sheet1!G3 Format = yyyy-mm-dd hh:mm:ss
Sheet1!G3 = 2014-02-11 07:00:00
Sheet2!I3 = "

Formula Results = "40219.2916666667"
Intended Formula Results = "2014-02-11 07:00:00"

I have used a similar formula for other fields within the xlsx, and the only one I am having issues is with the date field. It keeps converting to a serial number when the calculation occurs and the copy and formatting occurs.
Would someone be able to assist me with this formula to get it to come out with the intended results?

Thank you very much

Jim

Try

=IF(Sheet1!A3="","",TEXT(Sheet1!G3,"yyy-mm-dd hh:mm:ss"))

I'm not sure if you actually NEED the quote marks around it, but you can still do the concatenate with the " in I3

Originally Posted by Jonmo1

Try

=IF(Sheet1!A3="","",TEXT(Sheet1!G3,"yyy-mm-dd hh:mm:ss"))

I'm not sure if you actually NEED the quote marks around it, but you can still do the concatenate with the " in I3

I attempted this and it still returned the serial number "40219.2916666667".
Is it returning the serial number instead of the date because I am adding the " before and after the date?

Depends on where exactly you put the " marks.
Put them before and after the TEXT function.
NOT before and after the G3 value inside the Text function.

=IF(Sheet1!A3="","",Sheet2!I3&TEXT(Sheet1!G3,"yyy-mm-dd hh:mm:ss")&Sheet2!I3)

Thank you so much, this has been driving me crazy of on on for over a month trying to figure out how to get rid of the serial number. I normally try to figure these things out on my own, before asking for help, doing so helps me remember how to do it and get a better understanding of how to do functions, but I hit the point of frustration on this one.

Glad to help, thanks for the feedback.