LinkBack URL
About LinkBacks
hello
have some difficulties displaying text with dates
in A1 i have a date of 10/10/2011
in B1
this is the result:
Please Login or Register to view this content.
the date today is 40826
suppose to be :
the result is 10/10/2011
thanks in advance.
concatenate with dates
hello
have some difficulties displaying text with dates
in A1 i have a date of 10/10/2011
in B1
this is the result:Please Login or Register to view this content.
the date today is 40826
suppose to be :
the result is 10/10/2011
thanks in advance.
Last edited by vlady; 10-12-2011 at 11:01 PM.
Try this:
="the result is "&TEXT(A1,"mm/dd/yyyy")
thanks for the quick reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks