Long Format for Date?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

How can I make this show the long format instead of short?

="Today's Date is" & " " & Date()
 
Note that you could put that space in the first string...

="Today's Date is " & Format(Date(),"long date")
 
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

A03- Date format in tables? 1
Medium Date format and calendar in Access 2007 1
#Type! error on form 6
Pivot table macro filter data between yesterday and today (date+time) 0
Date format in a combo box 1
Excel Colour code dates 1
Excel How to change the "Short Date" format in Excel? 4
Formatting Dates for Display in Multiple Regions 3

Back
Top