| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine text with funny date format
We have some sql source data in an unusual format for a date that
reads (for example): 20070630 (yyyymmdd). Would like to link to that cell and have the result display a more readable format; combining some text, and transforning the format of the date. It would read something like: "Month Ending 6/30/2007". Ideas? TIA for them. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Find date duplicates Col 2 or Col 3 then combine Col 1 text | Excel Worksheet Functions | |||
| Combine text and today's date in a cell | Excel Worksheet Functions | |||
| Date looks funny! | Excel Discussion (Misc queries) | |||
| Combine date with text | Excel Worksheet Functions | |||
Threaded Mode
