View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Excel Date Question

T created a spreadsheet with a Date column and want the format to be 02/19/06
but I want to be able to type in the six digits without typing in the slashes.

Typing in today's date of 021906, you get 12/22/59, the 21,906th day of
(last) century.

Is these a way to format the cell to be able to type just 6 digits and get
the correct date?

Thanks