Thread: Format cells for date or time without having to enter the / or :
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Darcyyc Darcyyc is offline
external usenet poster
  
Posts: 1
Default Format cells for date or time without having to enter the / or :
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