While perhaps not as "alerting" to it being a comment as the N function is,
you can save 4 characters and a function call by doing it this way...

=A1&" should be paid on: "&TEXT(B1,"mm/dd/yyyy")&LEFT("due date of
payment",0)

--
Rick (MVP - Excel)


"Bob Phillips" wrote in message
...
I have often used N to resolve a numeric value, such as in OFFSET.



If you want a comment in a text result, you can combine N & T

=A1&" should be paid on: "&TEXT(B1,"mm/dd/yyyy")&TEXT(N("due date of
payment"),"")

--
__________________________________
HTH

Bob

"smartin" wrote in message
...
Nice one! I don't think I've ever had a use for N() until now.

Bob Phillips wrote:
=126.22+N("Mechanic")+38.56+N("Medication")+37.93+ N("Rubios bar and
grill")