View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default How do I change 2.8.03 to 2/8/03?

I have a large Excel sheets with a list of dates. The problem is they are
listed with periods separating the components. Is there a quicker way to
convert them into the standard format with slashes than manually entering
them myself?