Sorry, once the cell is formatted as I described, then just enter the date in
a normal fashion, like 12/9/04 and it will automatically appear as you
wished. When you just typed 2004 in the cell and moved away, Excel
interpreted the 2004 as a date-number which it sees as the "1905-June-26"
display you saw. The date 12/9/04 is actually just the number 38330 as far
as Excel is concerned, just the formatting changes it's appearance. Once the
cell is formatted, you could just type 38330 in it and the "2004-December-09"
would show on the display.

Vaya con Dios,
Chuck, CABGx3





"tandem" wrote:

I tried, but when I type year in cell, then click somewhere, i got the
following: 1905-junijs-26

tandem





"CLR" wrote in message
...
You can do it on a per-cell basis by Right-click on the cell, then
FormatCells NumberTab Custom and entering the following in the
window

yyyy-mmmm-dd


Vaya con Dios,
Chuck, CABGx3


"tandem" wrote:

I want set date format 2004-December-09 in my invoicing spreadsheet (only
in
this specific Excel spreadsheet, not at a system level). How I can do
this?

Thanks