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

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

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

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

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

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

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

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

I use Office XP english vers. WinXP engl. vers. What is problem for?

thanks,
tandem


"Frank Kabel" wrote in message
...
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

Hi
this is probably due to the Windows System settings

--
Regards
Frank Kabel
Frankfurt, Germany

"tandem" schrieb im Newsbeitrag
...
I use Office XP english vers. WinXP engl. vers. What is problem for?

thanks,
tandem


"Frank Kabel" wrote in message
...
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

With your date in B1, you could set up a VLOOKUP table to "translate" the
months to whatever you want and use something like this formula in another
cell...

=YEAR(B1)&"-"&VLOOKUP(MONTH(B1),Translate,2,FALSE)&"-"&DAY(B1)

Vaya con Dios,
Chuck, CABGx3



"tandem" wrote:

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