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 ✓ - Facebook Forum
Why do we not open our account having the same username? ✓ - Gmail Forum
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
We received your information ✓ - Facebook Forum
Facebook account not match - Laptop 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

i can't enter to my account facebook

Valid Mobile Number Not Recognized

my account closed.

facebook login without any info(advanced recovery solution) NO INFO AT ALL

Similar discussions

Subscribe To Our Newsletter!