Unoffical empeg BBS

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

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

Registered: 08/07/1999
Posts: 5539
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.]
Happy Birthday larry818
old hand

Registered: 01/10/2002
Posts: 1033
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: 5539
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