View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Set date format in Template in Excel

If it's a template, you could change the format of each of the cells to what you
want.



falcios wrote:

Is there a way to set in the template so that all dates entered show as
2/6/10 not as 02/06/2010?

Thanks in advance.


--

Dave Peterson