|
Date format in spreadsheet
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 |
| All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com