View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tankerman tankerman is offline
external usenet poster
 
Posts: 60
Default Enter date and time in cell

Is there any way of entering the date and time without having to put the
separtors in (01/01/2007 21:15), how can I just enter the numbers
010120072115 and have EXCEL put the separtors in for me, can I get my cells
to look like this somehow or am I just hoping for too much _ _ / _ _ / _ _
_ _ / _ _ : _ _