Free Excel Addins

[vgr]

Hi,

I am currently running the 64 bit version of excel 2013. Are you aware of any add in like ASAP utilities that will work with this version?
I am looking for the date fixing feature in particular. For instance, 12-03-2014 would show u in my data as 12/03/14 or 12.3.2014
ASAP utilities fixes it up pretty easily. would be great if you could possibly give me more information on the same.
Thanks

 

[mole999]

you can easily do proper dates as a change of formatting

ASAP is great for routines that don't have a default in excel

 

[Richard Schollar]

Date fixing implies it isn't simply a formatting issue.

Data>TextToColumns>Next>Next>choose Import Format of Date>DMY (or MDY)>Finish

should correctly convert text dates to real dates.