View Single Post
  #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