Reformating large amount of data

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Right now I have a fresh data set extracted from some database and sent to me
in an excel file. The date field is in the current format: YYYY-MM-DD. I
need it to be in MM-DD-YYYY. So, I thought I could achieve this by simply
highlighting the cells and changing the format to the correct date format.
However, when I do this nothing changes unless I actually double click in the
cell...then it will re-format the data how I want to view it.

In addition to this problem, when I try to import my data set into Access,
it will only import the cells that I double click in to change it to the date
format. The others are not getting pulled in because Access isn't reading
them as a date.

Is there any way to re-format all the cells without having to double click
in each one?

Any help would prove to be beneficial.

Thanks,
Jason
 
Enter 1 into an empty cell, right click the cell 'Copy'
Highlight the whole range with the dates in it, rightclick in the range,
'Paste Special', check 'Multiply' > OK.
Regards,
Alan.
 
That worked! Thanks!

Alan said:
Enter 1 into an empty cell, right click the cell 'Copy'
Highlight the whole range with the dates in it, rightclick in the range,
'Paste Special', check 'Multiply' > OK.
Regards,
Alan.
Click to expand...
 

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

Excel 2002: How to make the date format uniform ? 1
cell format - not automatically taking effect 4
Date Format Not Responding to MM/DD/YY 2
date 1
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
counting records by month and year / date format issues 1
Date format changes in mail merge using Excel worksheet as data 2
data turned in date format when copied 2

Back
Top