Excel question | Off Topic | unofficial empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

You are not logged in. [Log In] empegbbs.com » Forums » General Discussion » Off Topic » Excel question

Topic Options

#370813 - 12/04/2018 12:42 Excel question
tanstaafl. carpal tunnel Registered: 08/07/1999 Posts: 5549 Loc: Ajijic, Mexico	I am marginally competent in Excel, but have encountered a problem that has me stumped. It seems pretty basic, but I cannot get this formula to work right: =CONCATENATE("Total due as of ",TODAY()," to Vincente") Everything works, except that the embedded TODAY() function displays as the pointer to the date (number of days since January 1, 1900) rather than the date itself. How can I fix this? tanstaafl. _________________________ "There Ain't No Such Thing As A Free Lunch"
Top

#370814 - 12/04/2018 12:58 Re: Excel question [Re: tanstaafl.]
larry818 old hand Registered: 01/10/2002 Posts: 1039 Loc: Fullerton, Calif.	="Total due as of "&TEXT(TODAY(), "mmmm dd, yyyy")&" to Vincente."
Top

#370816 - 13/04/2018 03:37 Re: Excel question [Re: larry818]
tanstaafl. carpal tunnel Registered: 08/07/1999 Posts: 5549 Loc: Ajijic, Mexico	Originally Posted By: larry818 ="Total due as of "&TEXT(TODAY(), "mmmm dd, yyyy")&" to Vincente." Sweet! Excel TEXT function, that is a new one to me, but you can bet I will be using it in the future. Limited capabilities, but for what it does there is no substitute short of going into VBA. Thank you! tanstaafl. _________________________ "There Ain't No Such Thing As A Free Lunch"
Top

View All Topics