Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concantenate columns with dates and text
The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers. Any advice would be greatly appreciated. Thank you. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concantenate columns with dates and text
In Excel, dates are stored as the number of days since the last day of the
nineteenth century (i.e. 1/1/1901 is day 1). Times are recorded as a fraction of a day. What you see when you type a date into Excel is that underlying number subjected to a date format. To work around this, you need to use the Text() function. This will change your date value to a text date with your chosen format. For example to see the A1 date in dd/mm/yyyy format together with the content of B1, use the following: =TEXT(A1,"dd/mm/yyyy") & " " & B1 -- Steve "Dazed and Confused" wrote in message ... The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly appreciated. Thank you. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concantenate columns with dates and text
Use the TEXT function to return a date, formatted to display as desired.
For example, if A2 contains your first date, use something like the following as part of your concatenation... TEXT(A2,"mmm d, yyyy") Change the format as desired. Hope this helps! http://www.xl-central.com In article , Dazed and Confused wrote: The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly appreciated. Thank you. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concantenate columns with dates and text
It sure does! Thanks.
"Domenic" wrote: Use the TEXT function to return a date, formatted to display as desired. For example, if A2 contains your first date, use something like the following as part of your concatenation... TEXT(A2,"mmm d, yyyy") Change the format as desired. Hope this helps! http://www.xl-central.com In article , Dazed and Confused wrote: The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly appreciated. Thank you. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Concantenate columns with dates and text
Thank you!
"AltaEgo" wrote: In Excel, dates are stored as the number of days since the last day of the nineteenth century (i.e. 1/1/1901 is day 1). Times are recorded as a fraction of a day. What you see when you type a date into Excel is that underlying number subjected to a date format. To work around this, you need to use the Text() function. This will change your date value to a text date with your chosen format. For example to see the A1 date in dd/mm/yyyy format together with the content of B1, use the following: =TEXT(A1,"dd/mm/yyyy") & " " & B1 -- Steve "Dazed and Confused" wrote in message ... The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concantenate columns with dates and text | Excel Discussion (Misc queries) | |||
concantenate text to date | Excel Discussion (Misc queries) | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions |