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
We couldn't find an account matching the login info you entered ✓ - Gmail Forum
The email address you entered is not associated with a facebook account. please enter an email address associated with the disabled facebook account. - Facebook Forum
Matching Names to Id Numbers - Excel 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

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

my account closed.

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

Facebook account not match

Similar discussions

Subscribe To Our Newsletter!