Unoffical empeg BBS

Quick Links: Empeg FAQ | Software | RioCar.Org | Hijack | jEmplode | emphatic
Repairs: Repairs | Addons: Eutronix | Cases

Topic Options
#370813 - 12/04/2018 12:42 Excel question
tanstaafl.
carpal tunnel

Registered: 08/07/1999
Posts: 5355
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: 986
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: 5355
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