| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format in a text string
I have a date in A1 and need to reference it in a line of text. So, in cell
A2, I used the string '="This figure is from " & a1'. But, the result looks like 'This figure is from 39230'. How do I write the formula so it would read the date as 5/28/07 instead? I tried formatting the cell as a date cell, but that didn't work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells based on text string contains | Excel Worksheet Functions | |||
| Format text string | Excel Discussion (Misc queries) | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| Date format in string | Excel Discussion (Misc queries) | |||
| Convert text string to date | Excel Worksheet Functions | |||
Threaded Mode
