Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
A simple question, I hope. I select custom display of "mmm-dd".
I'm used to my old Excel where I enter "11-5" which displays "Nov 05". When I try this with this new Excel it displays "May 11". Yes, I can enter "5-11" & get "Nov 05" but is there a way to allow me to enter it in the old way (that I'm used to)?? -- Stan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
It is probably due to the default date format on your computer...
Try 11/5/2008 in any cell which is not formatted as mmm-dd then format it to mmm-dd. I think you will get 5-11... You can change your date settings through Control Panel | Regional and Language Settings. "stallen34" wrote: A simple question, I hope. I select custom display of "mmm-dd". I'm used to my old Excel where I enter "11-5" which displays "Nov 05". When I try this with this new Excel it displays "May 11". Yes, I can enter "5-11" & get "Nov 05" but is there a way to allow me to enter it in the old way (that I'm used to)?? -- Stan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
Hi,
By old and new what do you mean, which versions? On my machine 2003 and 2007 give Nov 05. I think you should check the country settings on your machine which suggests this is not a version issue but a computer setting. If this helps, please click the Yes button. Cheers, Shane Devenshire "stallen34" wrote: A simple question, I hope. I select custom display of "mmm-dd". I'm used to my old Excel where I enter "11-5" which displays "Nov 05". When I try this with this new Excel it displays "May 11". Yes, I can enter "5-11" & get "Nov 05" but is there a way to allow me to enter it in the old way (that I'm used to)?? -- Stan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
You'll just have to accept that, exceptionally, something has been written
from a British point of view! Next thing will be spellchecker correctly accepting 'colour' !! Only having fun. Don't have the answer but will try. "stallen34" wrote: A simple question, I hope. I select custom display of "mmm-dd". I'm used to my old Excel where I enter "11-5" which displays "Nov 05". When I try this with this new Excel it displays "May 11". Yes, I can enter "5-11" & get "Nov 05" but is there a way to allow me to enter it in the old way (that I'm used to)?? -- Stan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
Thanks Sheeloo. The control panel was the culprit. Now it works just fine
with "U.S. English". -- Stan "Sheeloo" wrote: It is probably due to the default date format on your computer... Try 11/5/2008 in any cell which is not formatted as mmm-dd then format it to mmm-dd. I think you will get 5-11... You can change your date settings through Control Panel | Regional and Language Settings. "stallen34" wrote: A simple question, I hope. I select custom display of "mmm-dd". I'm used to my old Excel where I enter "11-5" which displays "Nov 05". When I try this with this new Excel it displays "May 11". Yes, I can enter "5-11" & get "Nov 05" but is there a way to allow me to enter it in the old way (that I'm used to)?? -- Stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
display the day of the date | Excel Discussion (Misc queries) | |||
Formula to Display Date n-Workdays from a Certain Date | Excel Discussion (Misc queries) | |||
X axis date - display beyond latest date. | Charts and Charting in Excel |