| Home |
| Search |
| Today's Posts |
|
#3
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. |
| 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 | |||
![Dazed and Confused[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
