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 ✓ - 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
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
The phone number you entered is not a valid mobile number for united states - WhatsApp 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

my account closed.

i can't enter to my account facebook

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

Facebook account not match

Similar discussions

Subscribe To Our Newsletter!