changing date formats

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

can you change a column of dates that read with hash marks to those without
and contain a 6 digit format. Example 7/1/09 to 070109
 
Certainly. Just use a custom format of ddmmyy or mmddyy, whichever one
applies.

Regards,
Fred.
 
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

Counting average number of days between 2 dates 3
Calculating date and placing the value in the right date range col 2
cell formatted as date won't change 3
adding differences between dates 6
rerturn latest date 1
Remove date format? 3
counting months 4
Percentage of dates that are 7 days late 3

Back
Top