Re: Date Strings in Excel?

Article View: comp.sys.mac.apps

Article #8622

#8622

From: Jann VanOver
Date: Tue, 23 Apr 1991 16:37

27 lines
1228 bytes

In article <6240@crystal9.UUCP> derosa@motcid.UUCP (John DeRosa) writes:
>derosa@motcid.UUCP (John DeRosa) writes:
>
>>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.
>
>This leads to my real question, how do you
>format a cell so that *ANY* information 
>entered into a cell is not altered in any
>way?
>-- 
Yes, John.

I think your original posting was close:
   ="April 24, 1991"
   ^

The equals sign is crucial.  It says "what follows is a formula that
needs to be evaluated".  Your "formula" is the string between the
quotes.  This will give you the string you want without it being
recognized (turned into) a date!

Have fun!
Jann E VanOver
vanover@atc.boeing.com

Technical Details

Message-ID: <45814@bcsaic.UUCP>

Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!batcomputer!cornell!uw-beaver!ssc-vax!bcsaic!vanover

References: <6224@crystal9.UUCP> <6240@crystal9.UUCP>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!batcomputer!cornell!uw-beaver!ssc-vax!bcsaic!vanover
From: vanover@bcsaic.UUCP (Jann VanOver)
Newsgroups: comp.sys.mac.apps
Subject: Re: Date Strings in Excel?
Message-ID: <45814@bcsaic.UUCP>
Date: 23 Apr 91 16:37:42 GMT
References: <6224@crystal9.UUCP> <6240@crystal9.UUCP>
Distribution: comp
Organization: Boeing Computer Services AI Center, Seattle
Lines: 27

Reply to Parent Message