Date entered wrongly

Ask a question ANJU BIDASARIA - Last answered on Aug 11, 2017 at 09:06 PM by ac3mark

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

plus moins
Isn't 4-24 shorter?

You can try:


...where a1=Apr 24


=text(a1,"mmm dd")

Give that a try!

Have fun!

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!