date to text (not serial number)

  • Thread starter Thread starter jsv
  • Start date Start date
Two possibles...

Just add a custom format. Right click the date and select Format Cells ->
Number tab -> Custom and change the format to ddmmyy

Or use the formula
=text(a1, "ddmmyy")
where your date is in A1.
 
=TEXT("02/11/09","mmddyyyy")

If the date is in A1 then use this in any other cell
=Text(a1,"mmddyyyy")
 
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

convert text to date 3
Date to TEXT. NOT to sequential serial number 2
macro to add numbers based on set criteria 6
Convert date to text 6
Conditional Formatting - Dates 2
Change date from yyyymmdd to valid date format 4
Converting dd:hh:mm to [h]:mm not working. 3
Sickness dates 4

Back
Top