On Tuesday 07 June 2005 08:38 pm, Don Jarvis wrote:
> I want to use month names, the date in digits and no year (EG June 7)
> on a spreadsheet. I cannot find how to do this within the Help menus
> nor are there any icons apparent which will allow this. Regardless of
> what I type, when I move to the next cell the date reads 06/07/05.
> Again, I want June 7.
>
> Please help.
>
> Don Jarvis
> [EMAIL PROTECTED]
If you have a row or column that you want formatted this way,
highlight the entire row(click the row number) or column(click the
column letter). Right click the highlighted row or column and select
Format Cells in the context menu. Make sure the "Numbers" tab is
selected. Click "Date" in the Category list. Down close to the bottom
of the Format Cells window is the Format code box. Enter MMMM DD (that
is four capital M's a space and two capital D's). Click the green check
to add this to the Format list. Click OK.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
