concatenate with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to make a sentance from various cells but the date comes out as a
serial number rather than the dd/mm/yy format I would like.

any ideas?
 
Use:
="Date is "&TEXT(A1,"dd mmm yyyy")

where cell A1 contains the date

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

The formatting within the quotes can be changed..........

Vaya con Dios,
Chuck, CABGx3
 
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
Excel Date 4
Conditional formatting of date-cell - 2007 5
date format 1
Preserving date format 1
Counting of a date from a range of Cells 2
convert serial date format to normal date format 3
Date formatting from user form to worksheet 6

Back
Top