Date concatenate?

  • Thread starter Thread starter Hilton
  • Start date Start date
H

Hilton

How do I concatenate two cells - one with a start date and the other with an
end date without Excel changing it to date values?

i.e I want to end up with 01/01/2006 - 31/12/2006 not 38718-39082
 

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

Help with Concatenation 3
Break links automatically changes graph's date format 5
How to set the value to zero if it negative after the substract 5
help with Sum in between dates 9
IF Function with Dates 9
help with format change of date part of concatenate formula 1
how to get the random date between the start date and the end date? 3
Concatenating Criteria in DSUM 2

Back
Top