Formating

G

Guest

I have a long list of dates example.
01/15/2007
03/13/2007
04/04/2007
04/09/2007
04/09/2007

that I would like to format into a shorter date format. For some reason when
I apply the new format it doesn't take until I click into each and every
cell. Problem is I have a couple thousand.

Thanks in adavance for the help.
 
G

Guest

It looks like your data is in a column. If this is so, use
Tools > Text to Columns
to change the format
 

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

Conditional Formatting - Dates 2
COUNT BETWEEN A SPECIFIC DATE RANGE 4
Lookup Maximum between Range of Dates 2
time_report_date-wise_employee-wise 6
How to count the occurrence? 3
Sumproduct with variation 1
moving date details 3
date format problem 1

Top