Date format in spreadsheet

[tandem]

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

 

[CLR]

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]

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

tandem

 

[CLR]

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]

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

 

[CLR]

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]

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

 

[Frank Kabel]

Hi
don't think this is possible

 

[tandem]

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

thanks,
tandem

 

[Frank Kabel]

Hi
this is probably due to the Windows System settings

 

[CLR]

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