Hi
don't think this is possible

--
Regards
Frank Kabel
Frankfurt, Germany

"tandem" schrieb im Newsbeitrag
...
Currently I get 2004-decembris-09 date format. It show month name on
latvian. How to set display this in english: 2004-December-09 ?
(without
changing system setting, if possible)

Tandem



Control Semicolon will put today's date in the cell.

I've seen pop-up calendars in the past but don't know where to get
them
anymore. Maybe someone else could help with that. Personally, by
the
time
I find them and make the selection, I could have just typed the
12/9/04 or
whatever, in myself.

Vaya con Dios,
Chuck, CABGx3



"tandem" wrote:

Is there a some way make date fill in to cell more handy? like
drop down
selector, etc.


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