Dates Format

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I have three cells.

The first cell has a date
The second cell has another date

I want to combine the two dates into one cell so it shows
DD/MM/YY - DD/MM/YY using the & function, but when I do
this, the second date is converted into the other format
of date (ie. 364346)

Is there any way to combine the two cells and keep the
date format?
 
Use the TEXT function

=TEXT(A1,"dd/mm/yy")&" - "&TEXT(A2,"dd/mm/yy")
 
Perhaps you can create a text string with something like:

=Text(A1,"DD/MM/YY") & " - " & Text(B1,"DD/MM/YY")
 
You must log in or register to reply here.

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

How do I delete merged cells in Excel without deleting the final d 5
date format 1
Conditional formatting of date-cell - 2007 5
Excel 2002: How to make the date format uniform ? 1
Preserving date format 1
change DD/MM/YY to MM/DD/YY 6
Excel Date 4
Can't graph data with Date Format with hours 2

Back
Top