| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert a monthnumber to text: 2 should become februari
I am using Excel 2002.
I have in column D the birthdate of persons (e.g.: 23-02-1962) I extract in column E, with the MONTH-function, the month (2 in my example) However I do not want the number 2, but the text februari. How can I do that? Thanks for any suggestions, Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Dates to text | Excel Discussion (Misc queries) | |||
| Convert to Text File | Excel Discussion (Misc queries) | |||
| Having macro convert text to numbers | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
