View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
falcios falcios is offline
external usenet poster
 
Posts: 27
Default Date format changes when inserting rows

I selected a column and formatted it so that the date displays ex. 3/12/09.
When I insert rows and type in the date it displays as 3/12/2009. Why does
the format change? How can I get it so I don't have to format the dates
individually or reformat the whole column.

Thanks.