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
The email you entered isn't connected to an account facebook ✓ - Facebook Forum
We couldn't find an account matching the login info you entered ✓ - Facebook Forum
Entered too many codes ✓ - Facebook Forum
My Facebook account doesn't exist anymore ✓ - 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

Valid Mobile Number Not Recognized

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

We received your account.

my account closed.

Similar discussions

Subscribe To Our Newsletter!