| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the date to change into the right format?
I need to be able to type 15/06/06 or 150606 and for it to change to
15-jun-06 when I leave the cell. I have tried all kinds of things, and usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can someone please tell me how to format the date cell properly? I have so many cover sheets to type for the month end...!Thank you! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set the date to change into the right format?
Did you try to format your cells to the format you want, in your case
Format/Cells/Date/[*chosse*]? Henk "Tab In The Office" wrote: I need to be able to type 15/06/06 or 150606 and for it to change to 15-jun-06 when I leave the cell. I have tried all kinds of things, and usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can someone please tell me how to format the date cell properly? I have so many cover sheets to type for the month end...!Thank you! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set the date to change into the right format?
Yes I did, and was only able to get it to work if I typed the month before
the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I tried a variety of formulas and created some too, but I didn't get it right! Thanks for your help! Tabitha "HEK" wrote: Did you try to format your cells to the format you want, in your case Format/Cells/Date/[*chosse*]? Henk "Tab In The Office" wrote: I need to be able to type 15/06/06 or 150606 and for it to change to 15-jun-06 when I leave the cell. I have tried all kinds of things, and usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can someone please tell me how to format the date cell properly? I have so many cover sheets to type for the month end...!Thank you! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set the date to change into the right format?
Tabitha: I think you can solve yr problem by Windows settings, not Excel
settings. Go to the Start Menu/Settings/Control Panel/Regional settings and choose for instance English (UK) instead of (US). HTH, Henk "Tab In The Office" wrote: Yes I did, and was only able to get it to work if I typed the month before the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I tried a variety of formulas and created some too, but I didn't get it right! Thanks for your help! Tabitha "HEK" wrote: Did you try to format your cells to the format you want, in your case Format/Cells/Date/[*chosse*]? Henk "Tab In The Office" wrote: I need to be able to type 15/06/06 or 150606 and for it to change to 15-jun-06 when I leave the cell. I have tried all kinds of things, and usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can someone please tell me how to format the date cell properly? I have so many cover sheets to type for the month end...!Thank you! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set the date to change into the right format?
Thank you for your help, Henk!
"HEK" wrote: Tabitha: I think you can solve yr problem by Windows settings, not Excel settings. Go to the Start Menu/Settings/Control Panel/Regional settings and choose for instance English (UK) instead of (US). HTH, Henk "Tab In The Office" wrote: Yes I did, and was only able to get it to work if I typed the month before the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I tried a variety of formulas and created some too, but I didn't get it right! Thanks for your help! Tabitha "HEK" wrote: Did you try to format your cells to the format you want, in your case Format/Cells/Date/[*chosse*]? Henk "Tab In The Office" wrote: I need to be able to type 15/06/06 or 150606 and for it to change to 15-jun-06 when I leave the cell. I have tried all kinds of things, and usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can someone please tell me how to format the date cell properly? I have so many cover sheets to type for the month end...!Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format | Excel Worksheet Functions | |||
| Date in numeric format | New Users to Excel | |||
| I cannot change the date format to English canada | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| change date function format in footer | Excel Worksheet Functions | |||
Hybrid Mode
