Thread: date entered display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kate kate is offline
external usenet poster
  
Posts: 112
Default date entered display
If I enter the date of 10/25/06 as 102506, I would like it to display as
10/25/06. What formla do I use. I have the column formatted as SHORT DATE
and it shows up as 8/24/2180.

Reply With QuoteReply With Quote