A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Difference between 8/15/2009 & 8/5/2009



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 02:59 PM posted to microsoft.public.excel.newusers
ghitorni
external usenet poster
 
Posts: 18
Default Difference between 8/15/2009 & 8/5/2009

Opened a new file, typed 8/15/2009 in A1, 8/16/2009 in A2, 8/5/2009 in A3.
Automatically, the last one gets converted to 08-05-2009, and right-aligned
also. Happens in all new files I create. Am I doing something wrong because
I wanted the same treatment for both earlier values which appear
left-aligned. Any clues? I am using excel 2007. Thanks

  #2  
Old May 17th, 2010, 03:15 PM posted to microsoft.public.excel.newusers
Dave Peterson[_2_]
external usenet poster
 
Posts: 69
Default Difference between 8/15/2009 & 8/5/2009

And you're trying to enter dates, right?

If you format that 8/5/2009 (converted to 08-05-2009) in an unambiguous date
format, like: mmmm dd, yyyy, I'm betting that you'll see:

May 8, 2009

If that's true, then excel won't touch the first two entries since their is no
month that corresponds to 15 or 16.

Excel uses the windows short date format (modified in Windows Control
panel|regional settings) to parse your entry.

And I'm guessing that your short date format is in dmy order.

So you can either change that windows setting or you can change the order you
enter your dates.



On 05/17/2010 08:59, Ghitorni wrote:
Opened a new file, typed 8/15/2009 in A1, 8/16/2009 in A2, 8/5/2009 in
A3. Automatically, the last one gets converted to 08-05-2009, and
right-aligned also. Happens in all new files I create. Am I doing
something wrong because I wanted the same treatment for both earlier
values which appear left-aligned. Any clues? I am using excel 2007. Thanks

  #3  
Old May 17th, 2010, 04:14 PM posted to microsoft.public.excel.newusers
ghitorni
external usenet poster
 
Posts: 18
Default Difference between 8/15/2009 & 8/5/2009

Thanks. But in Vista, that's the only format, dd-mm-yy and since I am from
India, I had chosen that locale. Does it mean that to get mm-dd-yy, I have
to change to some other country time zone?
"Dave Peterson" wrote in message
...
And you're trying to enter dates, right?

If you format that 8/5/2009 (converted to 08-05-2009) in an unambiguous
date format, like: mmmm dd, yyyy, I'm betting that you'll see:

May 8, 2009

If that's true, then excel won't touch the first two entries since their
is no month that corresponds to 15 or 16.

Excel uses the windows short date format (modified in Windows Control
panel|regional settings) to parse your entry.

And I'm guessing that your short date format is in dmy order.

So you can either change that windows setting or you can change the order
you enter your dates.



On 05/17/2010 08:59, Ghitorni wrote:
Opened a new file, typed 8/15/2009 in A1, 8/16/2009 in A2, 8/5/2009 in
A3. Automatically, the last one gets converted to 08-05-2009, and
right-aligned also. Happens in all new files I create. Am I doing
something wrong because I wanted the same treatment for both earlier
values which appear left-aligned. Any clues? I am using excel 2007.
Thanks


  #4  
Old May 17th, 2010, 04:59 PM posted to microsoft.public.excel.newusers
Dave Peterson[_2_]
external usenet poster
 
Posts: 69
Default Difference between 8/15/2009 & 8/5/2009

It's a windows setting.

Go to the control panel (windows start button|control panel or settings, then
control panel).

Look for regional and language options
I'm using WinXP, so the captions may not be the same.

On the Regional Options tab, hit the Customize button.
Then go to the Date Tab

Make sure the short date format is in the same order as the way you want to
input dates.

Formatting the cell in excel won't change the order for entering the dates -- it
only displays the value entered in the way you want.





On 05/17/2010 10:14, Ghitorni wrote:
Thanks. But in Vista, that's the only format, dd-mm-yy and since I am
from India, I had chosen that locale. Does it mean that to get mm-dd-yy,
I have to change to some other country time zone?
"Dave Peterson" wrote in message
...
And you're trying to enter dates, right?

If you format that 8/5/2009 (converted to 08-05-2009) in an
unambiguous date format, like: mmmm dd, yyyy, I'm betting that you'll
see:

May 8, 2009

If that's true, then excel won't touch the first two entries since
their is no month that corresponds to 15 or 16.

Excel uses the windows short date format (modified in Windows Control
panel|regional settings) to parse your entry.

And I'm guessing that your short date format is in dmy order.

So you can either change that windows setting or you can change the
order you enter your dates.



On 05/17/2010 08:59, Ghitorni wrote:
Opened a new file, typed 8/15/2009 in A1, 8/16/2009 in A2, 8/5/2009 in
A3. Automatically, the last one gets converted to 08-05-2009, and
right-aligned also. Happens in all new files I create. Am I doing
something wrong because I wanted the same treatment for both earlier
values which appear left-aligned. Any clues? I am using excel 2007.
Thanks


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.