Re: Naming a (date) constant

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 11/29/04 

Date: Tue, 30 Nov 2004 01:08:57 +0800

Hi Bob

(won't even ask how you came up with this one!) but what i will ask is using
both yours and Frank's method i'm getting the serial number returned in the
cell rather than a "date" ... i know its just a matter of formatting it, but
is there anyway when using a date in this way, for excel to "automatically"
format it correctly?

Cheers
JulieD

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uXqU0Kh1EHA.1124@tk2msftngp13.phx.gbl...
> or
>
> =--("2004/11/29")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:1F1E13EE-362F-4D70-9532-A5C111CD1E91@microsoft.com...
>> Hi
>> try for example
>> =DATE(2004,11,29)
>>
>> "David" wrote:
>>
>> > Greetings & TIA for your help
>> > I can name a constant with Insert|Name|Define then type "MyConstant"
>> > and
>> > type =500 in "Refers To".
>> > How do I enter a date in the "refers to" box?
>> > --
>> > David
>
>

Quantcast