dd/mm/yy to mm/dd/yy

  • Thread starter Thread starter joao
  • Start date Start date
If you right click the mouse on the cell and choose Format cells, go t
the number tab and click on Custom in the Type box enter your forma
dd/mm/yy.

You can use this method to change the format to any other date forma
that does not appear in the standard date list
i.e. dd mmm yyyy would give 11 Nov 2003
and ddd dd mmmm yyyy would give Tue 11 November 2003

Hope this helps

Mik
 
Select the cells and use Format/Cells/Number/Custom and enter as you
wish or select from list provided

DavidP
 
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

change DD/MM/YY to MM/DD/YY 6
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Change from mm/dd/yy to yy/mm> 3
Preserving date format 1
Convert date to text without changing format dd/mm/yy 3
date format 1
visual basic user form date format dd/mm/yy not mm/dd/yy 1
Date Format Not Responding to MM/DD/YY 2

Back
Top