Thread: How do I enter a date without using slashes or dashes?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I enter a date without using slashes or dashes?
Sue

You cannot format for this.

See Chip Pearson's site for quick date entry.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Thu, 1 Mar 2007 06:10:30 -0800, Sue Miller <Sue
wrote:

I want to be able to enter, for example, "030107" and have the cell formatted
so I get 03/01/07.

Reply With QuoteReply With Quote