Free Excel Addins

vgr

New Member
Joined
May 25, 2012
Messages
15
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,281
Office Version
2019, 2016, 2013
Platform
Windows
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

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,375
Messages
5,444,099
Members
405,266
Latest member
Ryokaki

This Week's Hot Topics

Top