PERFECT !
Many thanks !!
On Monday, 23 September 2013 19:20:16 UTC-4, Ayush Jain wrote:
> =VALUE(TEXT(TODAY(),"MMDD"))
>
>
> On Tue, Sep 24, 2013 at 12:10 AM, Bill Q
> > wrote:
>
>> Excellent Is there something that can be added to the code so that
>> the returned value is in a nume
=VALUE(TEXT(TODAY(),"MMDD"))
On Tue, Sep 24, 2013 at 12:10 AM, Bill Q wrote:
> Excellent Is there something that can be added to the code so that the
> returned value is in a numeric value ?
>
>
> On Monday, 23 September 2013 18:48:32 UTC-4, Ayush Jain wrote:
>
>> =TEXT(A1,"MMDD")
>
Excellent Is there something that can be added to the code so that the
returned value is in a numeric value ?
On Monday, 23 September 2013 18:48:32 UTC-4, Ayush Jain wrote:
> =TEXT(A1,"MMDD")
> OR
> =TEXT(Today(),"MMDD")
>
>
>
> On Mon, Sep 23, 2013 at 11:46 PM, Bill Q
> > wrote:
=TEXT(A1,"MMDD")
OR
=TEXT(Today(),"MMDD")
On Mon, Sep 23, 2013 at 11:46 PM, Bill Q wrote:
> Can someone please tell me how to create a formula that will transpose the
> "today" function to a 8 digit numerical value ? The today function would be
> in cell A1... B1 would return the valu
Can someone please tell me how to create a formula that will transpose the
"today" function to a 8 digit numerical value ? The today function would be
in cell A1... B1 would return the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
