Formula for Changing date format 3-12-13 to format d-mm-yy.

**UNAB** · 04-08-2013, 03:38 PM

Hi

I have a long list of dates that are fomatted as 3-12-13 that I want to format under custom date as d-mmm-yy : 12-Mar-13. I tried to do this but it does not change. I tried to change it to a number and that didn't work either. Any help is appreciated.

Thank you!!
Una

**FDibbins** · 04-08-2013, 03:42 PM

your "dates" are not dates/values, they are actualy text that looks like a date - you wont be able to format them as anything like they are.

in B7, copied down, use this...
=A7*1

you can then format the results as you want. Also, you can either just hide your original data or copy/paste values from the formula over the original data and delete the formulas

A quick test for text looking like value is =isnumber(cell_ref) FALSE is text

**UNAB** · 04-08-2013, 03:52 PM

I was thinking that... the date was not really a date or it would have changed when I tried to format it.
Your answer worked perfectly.

Thank you so much, FDibbins!!! Have a great night.