Text and dates into one cell without loosing date format

G

Guest

How can I put text and dates into one cell without loosing the date format.
I can use & and concatenate but the date format always gets lost.
 
G

Guest

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

A1=Text
B1=Date (in DD/MM/YYYY or other Date format)

HTH
 
G

Guest

Here's a guess at what you might need...

For A1: (a date)
B1: ="This is my date: "&TEXT(A1,"mm/dd/yyy")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 

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

Changing dates to date format 5
Date Format 3
format text to date results in ############## 4
Date Formating Problem 1
Formatting Text to Numbers for Dates 1
Copnvert dates reading as Text to a date format 5
retain custom date format "text" when pasting or reformatting data 2
Pivot Table Change to US Date Format - Why? 2

Top