hello
have some difficulties displaying text with dates
in A1 i have a date of 10/10/2011
in B1
this is the result:![]()
="the date is " & A1
the date today is 40826
suppose to be :
the result is 10/10/2011
thanks in advance.
hello
have some difficulties displaying text with dates
in A1 i have a date of 10/10/2011
in B1
this is the result:![]()
="the date is " & A1
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)
Bookmarks