Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting in Excel
In Excel, how do I get my date to read like this: June 2008. I do not seem
to have this format available in the date formatting window for Excel. Can I create a new date format? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting in Excel
choose custom under Number category and enter:
mmmm yyyy it will display any date with full month name and year, no day. This does not changed what is stored in the cell, it will still be the actual date when used in sorts or formulas.... "Ricky4" wrote: In Excel, how do I get my date to read like this: June 2008. I do not seem to have this format available in the date formatting window for Excel. Can I create a new date format? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting in Excel
Create a custom format of mmmm yyyy
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ricky4" wrote in message ... In Excel, how do I get my date to read like this: June 2008. I do not seem to have this format available in the date formatting window for Excel. Can I create a new date format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formatting in Excel Urgent | Excel Discussion (Misc queries) | |||
date formatting in excel | Excel Worksheet Functions | |||
Eliminate Excel date formatting | Excel Discussion (Misc queries) | |||
Formatting the Date in Excel | Excel Discussion (Misc queries) | |||
Date formatting in Excel | Excel Discussion (Misc queries) |