|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 21st, 2009, 08:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as text
using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so? 
|
|
#2
December 21st, 2009, 08:20 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
assuming your date is in cell A1:
="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
|
#3
December 21st, 2009, 08:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
Hi
Try this: =A1 & " " & TEXT(A3,dd.mm.yy") where date is in A3 Hopes this helps. .... Per "lightbulb" skrev i meddelelsen ... using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
|
#4
December 21st, 2009, 08:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
Or, simpler,
="Heading test"&TEXT(A1,"dd/mm/yyyy") Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Mon, 21 Dec 2009 12:20:01 -0800, cm wrote: assuming your date is in cell A1: ="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
|
|
#5
December 21st, 2009, 08:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
This is close....for example my date is 05/01/2010, and after the formula, it
reads 1/5/2010....further help? "cm" wrote: assuming your date is in cell A1: ="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
|
#6
December 21st, 2009, 08:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
switch places with the day and month:
="text "&MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: This is close....for example my date is 05/01/2010, and after the formula, it reads 1/5/2010....further help? "cm" wrote: assuming your date is in cell A1: ="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
|
#7
December 21st, 2009, 08:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
Or shorter,
="text "&Text(a1,"mm/dd/yyyy") Regards, Fred "cm" wrote in message ... switch places with the day and month: ="text "&MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: This is close....for example my date is 05/01/2010, and after the formula, it reads 1/5/2010....further help? "cm" wrote: assuming your date is in cell A1: ="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1) -- hope to help, cm "lightbulb" wrote: using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
|
#8
December 21st, 2009, 11:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates as text
="Column Heading " & TEXT(A1,"mm-dd-yyyy")
Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 12:16:01 -0800, lightbulb wrote: using a formula, I am combining a column heading and the date in that row, so that the cell will read "Column Heading Date", but the date is showing as a number rather than a date. I want the cell to contain both txt (column heading), and a date. How do I format it to do so?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
