Thread: I format for date but it is calculating
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default I format for date but it is calculating
As far as I am aware, dates must entered as mm/dd/yy(yy) or mm-dd-yy(yy) i.e.
you need the delimeters.

Using VBA, it would be possible to allow entry as you tried and convert to a
date.

HtH

"Tory" wrote:

Okay, I understand that Excel is thinking the number I am putting in (060806)
is a serial number for the date of 03/19/69. Is there a way to make it do
what I want. i didn't see it on www.cpearson.com/excel/datetime.htm

"Tory" wrote:

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