| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine day text and date problems
Hi,
I have the day of the week in A1 and the date in A2 and I'm trying to combine them in A3 so it's appear as "10/1/08 Wednesday" but when I apply the formula it comes out as (please see below in results). How can I do it so it'll come out the way i want? A1: Wednesday A2: 10/1/2008 Results: Wednesday 39722 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine text with funny date format | Excel Worksheet Functions | |||
| Find date duplicates Col 2 or Col 3 then combine Col 1 text | Excel Worksheet Functions | |||
| Combine text and today's date in a cell | Excel Worksheet Functions | |||
| problems trying to combine two sheets | Excel Discussion (Misc queries) | |||
| Combine date with text | Excel Worksheet Functions | |||
Threaded Mode
