Date entered wrongly

Closed

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

Hello,

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

Date entered wrongly
We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
My Facebook account doesn't exist anymore ✓ - Facebook Forum
We couldn't find an account that matches what you entered, but found one that closely matches. - Laptop Forum
Google couldn't verify that this belong to you - Gmail Forum
We couldn't find an account matching the login info you entered ✓ - Facebook Forum

1 response

Answer 1 / 1

Blocked Profile
Updated on Aug 11, 2017 at 09:09 PM

Isn't 4-24 shorter?

You can try:

=text(a1,"MMM-DD")

...where a1=Apr 24

...or...

=text(a1,"mmm dd")

Give that a try!

Have fun!

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

Similar discussions

Facebook says that my email doesn't match my facebook email

We received your account.

Valid Mobile Number Not Recognized

We received your information

My Facebook account is disabled

Similar discussions

Subscribe To Our Newsletter!