Date Strings in Excel?

Article View: comp.sys.mac.apps

Article #8542

#8542

From: John DeRosa
Date: Thu, 18 Apr 1991 14:30

26 lines
1269 bytes

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 =

Technical Details

Message-ID: <6224@crystal9.UUCP>

Path:

arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!casbah.acns.nwu.edu!ftpbox!motsrd!motcid!derosa

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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