Combine 2 cells into 1 - But I'm puzzeled on how to format a Date I'm combining :(

[admiralkush]

Good morning all!

I'm using a very simple method to combine two cells into one: =(A2&" "&A3)

The only problem I'm having is the date in A3 gets carried over in ddmmyyyy (regardless of cell formatting - I've tried!)

Does anyone have a solution to when A3 is carried over, it's date will be in yymmdd? Or is there a custom formatting I could use and apply to the entire column or fix this?

Much appreciated!

[admiralkush]

I think a table of what I'm working with would help. I made a mistake above and the format that pulls over is actually: mmddyy - But I need it to be in yymmdd.

Shipment # Rcvd Date
5064104914 42115 5064104914 4/21/2015

What I get is above but what I need is below:

Shipment # Rcvd Date
5064104914 150421 5064104914 4/21/2015

Thank you!

[samba_ravi]

will you pls attach sample excel file

[admiralkush]

Shipment # Rcvd Date Combined Column What it should be
5064104914 4/21/2015 5064104914 42115 5064104914 150421
5064104925 4/22/2015 5064104925 42116 5064104925 150422
5064104947 4/23/2015 5064104947 42117 5064104947 150423
5064104958 4/24/2015 5064104958 42118 5064104958 150424

[Special-K]

Dates are stored in an internal format within Excel using consisting of a 5 digit number
So when you manipulate a date you're manipulating a 5 digit number, even though it looks like a readable date.
Try using

=TEXT(A1,"mm/dd/yyyy") or =TEXT(A1,"dd/mm/yyyy") to turn the 5 digit number into a readable date.

[admiralkush]

Thanks a lot Special K!