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?
=TEXT(A1,MMDD)
OR
=TEXT(Today(),MMDD)
On Mon, Sep 23, 2013 at 11:46 PM, Bill Q ronsmith...@gmail.com 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
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 ronsm...@gmail.com
=VALUE(TEXT(TODAY(),MMDD))
On Tue, Sep 24, 2013 at 12:10 AM, Bill Q ronsmith...@gmail.com 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:
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 ronsm...@gmail.com javascript:
wrote:
Excellent Is there something that can be added to the code so that
the returned