if your column contains text (sounds like it does but you can verify by
using ISTEXT or TYPE - Type will return "2" if it's text) then you can
convert the values to a number by using VALUE. You have to insert a
column first (ideally to the left). Let's say you have a date in the
cell C2 and B is the new column you added. Type "=VALUE(C2)" in cell
B2. That will convert your string date (as long as it's in a date
format that Excel recognizes) to a number date. It will be formatted as
a number initially but you can now apply the date formats. If this is a
one time change, I would copy paste values on column B and then
delete column C so it's cleaner to work with.


--
doucetrr
------------------------------------------------------------------------
doucetrr's Profile: http://www.excelforum.com/member.php...o&userid=24872
View this thread: http://www.excelforum.com/showthread...hreadid=384138