How do I formate cells in excell to show inputed date as 09/13/

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

Guest

I have been trying to format colum A to show dates of financial transactions.
I would like to be able to do this in the traditional way of mm/dd/yy. Any
help anyone could offer me would be greatly appreciated. I was ok on
previous versions of Excell, but frankly, I am lost on this version.
 
Select the column
Click Format > Cells > Number tab
Choose "Custom", then in the "Type:" box, enter: mm/dd/yy
 
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 date format in Excel footer 2
Stop Excel Changing Format 3
DATE FORMAT NOT WORKING 5
Date Format 3
Date format in Excel 2007 mm/dd/yy not appearing correctly 2
can I change the date format as dd-mm-yy 7
separating date and time 5
How to enter a date in DD-MM-YYYY format 2

Back
Top