Thread: Format cells for date or time without having to enter the / or :
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Format cells for date or time without having to enter the / or :
Cannot be done without VBA

See Chip Pearson's site for quickentry code.

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


Gord Dibben MS Excel MVP

On Tue, 14 Oct 2008 07:40:02 -0700, Darcyyc
wrote:

I am trying to find out how to enter date and enter time without entering the
/ and the : each time; i.e. 12312007 and have it appear as 12/31/2007 or 831
and have it appear as 8:31. I used to know how to do this but have
forgotten...duh!

Reply With QuoteReply With Quote