| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine day text and date problems
I'm trying to combine them...so it's appear as "10/1/08 Wednesday"
One way: =TEXT(A2,"m/d/yyyy dddd") -- Biff Microsoft Excel MVP "mike" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine day text and date problems
=a1&text(a2,"m/d/yyyy")
or =a1&char(10)&text(a2,"m/d/yyyy") (with wrap text checked) mike wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore
Ignore this...
A1: Wednesday A2: 10/1/2008 Results: Wednesday 39722 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine day text and date problems
=TEXT(A2,"m/d/yyyy dddd")
so it's appear as "10/1/08 Wednesday" Well, looks like I wasn't paying attention! Try it like this: =TEXT(A2,"m/d/yy dddd") Result = 10/1/08 Wednesday -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... I'm trying to combine them...so it's appear as "10/1/08 Wednesday" One way: =TEXT(A2,"m/d/yyyy dddd") -- Biff Microsoft Excel MVP "mike" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore
Ignore this...
OK -- Biff Microsoft Excel MVP |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore
Go the long way around..
=month(A2)&"/"&day(A2)&"/"&year(A2)&" "&A1 "mike" wrote: Ignore this... A1: Wednesday A2: 10/1/2008 Results: Wednesday 39722 |
| Reply |
| 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 | |||
Linear Mode
