View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jodi Bauman Jodi Bauman is offline
external usenet poster
 
Posts: 1
Default Formatting date & time

I am importing a file from another program and the date
and time displays as follows: 200403111449. How do I
format this date, so that it shows 3/11/04 14:49 - either
in 1 or 2 cells.