Thread: I format for date but it is calculating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tory Tory is offline
external usenet poster
  
Posts: 5
Default I format for date but it is calculating
I formatted column for date, ie mm/dd/yy

However, when I enter in 060806 I get 03/19/69

I want to see 06/08/06. What is wrong?

I think it is making some sort of calculation.
Reply With QuoteReply With Quote