Format cells for date or time without having to enter the / or :

  • Thread starter Thread starter Darcyyc
  • Start date Start date
D

Darcyyc

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!
 
Back
Top