Naming a (date) constant
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 |
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 |
or
=--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... 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 |
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" wrote in message ... or =--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... 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 |
Julie,
Not to keep it as a date, but you can use =TEXT(--("2004/11/29"),"dd mmm yyyy") which returns it as text, although you can do math on it -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... 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" wrote in message ... or =--("2004/11/29") -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... 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 |
All times are GMT +1. The time now is 04:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com