| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting date into plain text
Folks,
I have a small problem. Let's say I have January 22, 2004 in one cell. Now this is set up as a Date format. Is there a way I can convert it into text so that I can do, for example, a left() function that's going to ask for the first 3 characters in that cell..i.e. bring back "Jan". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting date to text | Excel Worksheet Functions | |||
| Converting TEXT to DATE | Excel Worksheet Functions | |||
| Converting text into Date Value | Excel Worksheet Functions | |||
| Converting text into Date Value | Excel Worksheet Functions | |||
| Converting number or text to a Date Format | New Users to Excel | |||
Threaded Mode
