View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teri Teri is offline
external usenet poster
 
Posts: 77
Default Automatically format number as date

I am creating a spreadsheet for non-Excel users. If I tell them to enter a
date, I'll see it fifteen different ways. I want to instruct them to enter
the date as xxxxxx. In other words, October 3, 2006 would be entered at
100306, but I want it to display 10/03/06. How can I do this?