keeping date formate when using concatenate fromula

  • Thread starter Thread starter Herman
  • Start date Start date
H

Herman

I am stuck with this one. I am trying to use the
concatenate formula with one of my reference cells
conataining a date. Is it possible to keep the date
formate without having to enter it manually?
 
Hi Herman!

Use something like:

="Today is "&TEXT(TODAY(),"dd-mmm-yyyy")



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Herman

If the date is in A2 try something like this

=DAY(A2)&"/"&MONTH(A2)&"/"&YEAR(A2)&", "&F2

This concatenates the date in A2 to the value in F2.

Regards
Peter
 
Herman

B1 contains This is

C1 contains the date

In A1 enter =B1& " " &TEXT(C1,"mmmm d" &"," &"yyyy")

Your choice of format, of course.

Gord Dibben Excel MVP
 
something like this should do the trick:

="As of"&" "& TEXT(A1,"mm,dd,yyyy")

or this =B1&" "& TEXT(A1,"mm,dd,yyyy")
 
Back
Top