Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting problem | Excel Worksheet Functions | |||
formatting problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Programming | |||
Formatting problem | Setting up and Configuration of Excel |