| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to concatenate text & date
How do I combine paydate & 01/02/09?
=concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. -- AcctCA755 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to concatenate text & date
One way:
=A1 & TEXT(B1," dd/mm/yy") In article , AcctCA755 wrote: How do I combine paydate & 01/02/09? =concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to concatenate text & date
If the date is in B1 then try
=A1 & (TEXT(B1,"mm/dd/yyyy")) "AcctCA755" wrote: How do I combine paydate & 01/02/09? =concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. -- AcctCA755 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to concatenate text & date
In A1 we have "payday "
In B1 put =TODAY() In C1 enter: =A1 & TEXT(B1,"mm/dd/yy") -- Gary''s Student - gsnu200827 "AcctCA755" wrote: How do I combine paydate & 01/02/09? =concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. -- AcctCA755 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to concatenate text & date
Try instead:
=A1&" "&TEXT(B1,"m/dd/yyyy") HTH, Jim "AcctCA755" wrote: How do I combine paydate & 01/02/09? =concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. -- AcctCA755 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to concatenate text & date
Thanks everyone it worked.
-- AcctCA755 "JMay" wrote: Try instead: =A1&" "&TEXT(B1,"m/dd/yyyy") HTH, Jim "AcctCA755" wrote: How do I combine paydate & 01/02/09? =concatenate(A1,B1) formats the date as 35983. I want the date to appear as 01/02/09. -- AcctCA755 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate a date and a # ID | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Date CONCATENATE | Excel Worksheet Functions | |||
| concatenate text and date | Excel Discussion (Misc queries) | |||
Linear Mode
