| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine text & date formula to show mmmm dd, yyyy?
How do I combine text and date formula to show the written date and not the
Excel number date? I have text in a couple of cells and a date formula in another cell(input from a different worksheet). I have the formula =A3 & F3 & A4 in A1 and would like it to read: We went to the station on December 21, 2009 and took the train. However, it is reading We went to the station on 40168 and took the train. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combine text & date formula to show mmmm dd, yyyy?
Try something like this...
A1 = Today is B1 = 12/21/2009 =A1&" "&TEXT(B1,"mmmm dd, yyyy") Returns: Today is December 21, 2009 -- Biff Microsoft Excel MVP "htm_temp1" wrote in message ... How do I combine text and date formula to show the written date and not the Excel number date? I have text in a couple of cells and a date formula in another cell(input from a different worksheet). I have the formula =A3 & F3 & A4 in A1 and would like it to read: We went to the station on December 21, 2009 and took the train. However, it is reading We went to the station on 40168 and took the train. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combine text & date formula to show mmmm dd, yyyy?
=today() in Cell A1
="We went to the station on "&TEXT(A1,"mmmm dd, yyyy")&"and took the train." in Cell C1 -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "htm_temp1" wrote: How do I combine text and date formula to show the written date and not the Excel number date? I have text in a couple of cells and a date formula in another cell(input from a different worksheet). I have the formula =A3 & F3 & A4 in A1 and would like it to read: We went to the station on December 21, 2009 and took the train. However, it is reading We went to the station on 40168 and took the train. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combine text & date formula to show mmmm dd, yyyy?
You need the Text function to convert the date to the format you want. Use:
=a3&text(f3,"mmmm dd, yyyy")&a4 Regards, Fred. "htm_temp1" wrote in message ... How do I combine text and date formula to show the written date and not the Excel number date? I have text in a couple of cells and a date formula in another cell(input from a different worksheet). I have the formula =A3 & F3 & A4 in A1 and would like it to read: We went to the station on December 21, 2009 and took the train. However, it is reading We went to the station on 40168 and took the train. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? | Excel Discussion (Misc queries) | |||
| want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy? | Excel Discussion (Misc queries) | |||
Hybrid Mode
