Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!casbah.acns.nwu.edu!ftpbox!motsrd!motcid!derosa
From: derosa@motcid.UUCP (John DeRosa)
Newsgroups: comp.sys.mac.apps
Subject: Date Strings in Excel?
Message-ID: <6224@crystal9.UUCP>
Date: 18 Apr 91 14:30:43 GMT
Distribution: comp
Organization: Motorola Inc., Cellular Infrastructure Div., Arlington Heights, IL
Lines: 26

I would like to be able to enter a date 
string of April 24, 1991 into an Excel
cell.  Unfortunately, Excel keeps converting
it to another format.

It either converts it to a number of days
since 1904 (general) or to another date format like
dd-mm-yy.

The closest that I have come to what I want
is either;

1) Put the date in quotes, but the quotes
show.

2) Format the date mmmm dd, yyyy.  This 
works for months with four letters but
truncates November to Nove, etc.  Is there
a more generic form of this?

Any ideas?
-- 
=       John DeRosa, Motorola, Inc, Cellular Infrastructure Group          =
= e-mail:    ...uunet!motcid!derosaj, motcid!derosaj@uunet.uu.net          =
= Applelink: N1111                                                         =
=I do not hold by employer responsible for any information in this message =