Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 4th 04, 12:35 AM
tk_2u
 
Posts: n/a
Default How can I format a cell so date field only displays the Month?

I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.

  #2   Report Post  
Old December 4th 04, 12:46 AM
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u"
wrote:

I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.


Format/Cells/Number Custom: mmmm


--ron
  #3   Report Post  
Old December 4th 04, 12:51 AM
CLR
 
Posts: n/a
Default

Right-click on the cell with the date in it FormatCells NumberTab
Custom ..type MMMM in the window

Vaya con Dios,
Chuck CABGx3


"tk_2u" wrote in message
...
I'd like to have cells with date fields only display the Month. Instead

of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.



  #4   Report Post  
Old December 4th 04, 12:54 AM
Gord Dibben
 
Posts: n/a
Default

FormatCellsNumberCustom.

Enter MMMM in the dialog box.

Gord Dibben Excel MVP

On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u"
wrote:

I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date on two lines using a custom cell format possible? .:mmac:. Excel Discussion (Misc queries) 5 December 4th 04 09:41 PM
How can I defeat Excel's auto-reformating into date format? stebro Excel Discussion (Misc queries) 2 December 2nd 04 03:39 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 02:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017