formatting problem

D

dial13

I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark
 
D

dial13

I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark

THANK YOU VERY MUCH WORKS LIKE A DREAM:) MUCH APPRECIATED
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top