keeping date formate when using concatenate fromula

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?
 
N

Norman Harker

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.
 
P

Peter Atherton

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
 
G

Gord Dibben

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
 
2

2rrs

something like this should do the trick:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Concatenate cells with line breaks in them 4
*Issue* Concatenate dates in a large range of cells in a row. 5
sheet name in workshhetfunction 2
Word doc keeps changing to ALL CAPS 0
date Concatenation 4
Autofill Date in Word 15.33 for Mac 0
help with format change of date part of concatenate formula 1

Top