I am trying to format a date that is currently like "10 Mar, 2015" to "03/10/2015" but no matter what I try the date isn't reformatting.
Please help!
-Paul
I am trying to format a date that is currently like "10 Mar, 2015" to "03/10/2015" but no matter what I try the date isn't reformatting.
Please help!
-Paul
Hi,
There is a big chance that in the cell, you are referring to is a text not date
If it is in more than one cell (for instance whole column, try selecting this column, data-> text to columns->separated->no separator selected at all->next and for the first column select date as data type and DMY as date parts arrangement.
Best Regards,
Kaper
Try this
B1 =DATEVALUE(SUBSTITUTE(A1,",","")) format as mm/dd/yyyy
A1 is assumed to be text.
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks