Date entered wrongly

ANJU BIDASARIA - Aug 10, 2017 at 01:15 PM
 Blocked Profile - Aug 11, 2017 at 09:06 PM

I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024' do I correct all such entries, if not manually..Please help

1 response

Isn't 4-24 shorter?

You can try:


...where a1=Apr 24


=text(a1,"mmm dd")

Give that a try!

Have fun!

It's kind of fun to do the impossible! -Walter Elias Disney