Date Formatting

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

Guest

I need to change the date format for a column from 01/15/2006 to 01152006 .
Is this possible to do?
Thanks
 
Custom format of mmddyyyyy

If you want it as text

=TEXT(cellref,"mmddyyyy") in a helper cell


Gord Dibben MS Excel MVP
 
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

countifs Function not giving desired result with date criteria 2
separating date and time 5
Problem formatting dates from CSV file 2
Trying to convert date to day 5
Need help with converting CUSTOM format/TEXT format to DATE format 6
running total by date (not sorted by date though...) 4
counting cells containing certain ranges of dates 1
Chart and date data 2

Back
Top