| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formula to convert date result to text
I used a formula to convert text into a specific date value. Now I
would like a formula to convert that result into text. The TEXT function may provide what you need. With a date in A1, try =TEXT(A1,"Mmm dd, yyyy") or =TEXT(A1,"mm/dd/yy") or =TEXT(A1,"Mmmm d, yyyy") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
| Convert Function Result To Plain Text | Excel Discussion (Misc queries) | |||
| HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(, | Excel Worksheet Functions | |||
| convert drop down text into result | Excel Discussion (Misc queries) | |||
| What is the formula to convert a whole column of date to text? | Excel Programming | |||
Threaded Mode
