| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Return Month in word form. 12=December
I am creating an Excel worksheet and need to take a date and find the month
of the date to display in another cell. I can make it display the number using the month(cellnumber) but what is the best way for it to display the word instead; instead of 12 display December? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Return Month in word form. 12=December
Just format the (complete) date Custom as "dddd"
So, 12/12/2001, formatted as dddd, will display as December -- Kind regards, Niek Otten Microsoft MVP - Excel "Dustin B" wrote in message ... |I am creating an Excel worksheet and need to take a date and find the month | of the date to display in another cell. I can make it display the number | using the month(cellnumber) but what is the best way for it to display the | word instead; instead of 12 display December? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Return Month in word form. 12=December
Well, that was a little too simple now wasn't it. I over complicated the
matter. Thanks for your help. "Niek Otten" wrote: Just format the (complete) date Custom as "dddd" So, 12/12/2001, formatted as dddd, will display as December -- Kind regards, Niek Otten Microsoft MVP - Excel "Dustin B" wrote in message ... |I am creating an Excel worksheet and need to take a date and find the month | of the date to display in another cell. I can make it display the number | using the month(cellnumber) but what is the best way for it to display the | word instead; instead of 12 display December? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Return Month in word form. 12=December
On Mon, 21 Jan 2008 21:10:01 +0100, "Niek Otten" wrote:
Just format the (complete) date Custom as "dddd" So, 12/12/2001, formatted as dddd, will display as December If you are using an m/d/y system (eg English), then you should use mmmm for the custom format --ron |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Return Month in word form. 12=December
Thanks, Ron! Fortunately the OP seems to have found the correct way
-- Kind regards, Niek Otten Microsoft MVP - Excel "Ron Rosenfeld" wrote in message ... | On Mon, 21 Jan 2008 21:10:01 +0100, "Niek Otten" wrote: | | Just format the (complete) date Custom as "dddd" | | So, 12/12/2001, formatted as dddd, will display as December | | If you are using an m/d/y system (eg English), then you should use mmmm for the | custom format | --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula copy for December | Excel Discussion (Misc queries) | |||
| How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
| Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
| Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Linear Mode
