Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thank you Niek,
I did not realize it is that simple. Rick "Niek Otten" wrote in message ... Don't extract the month. Just use =D1 and format Custom as "mmmm" If you require it to be text, use =TEXT(D1,"mmmm") -- Kind regards, Niek Otten Microsoft MVP - Excel "Ricky Gibson" wrote in message . .. |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 | |
|
|
![]() |
||||
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) |