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
Enter date in format dd/mm/yyyy - Guide
The email you entered isn’t connected to an account. find your account and log in. - Outlook Forum
The email you entered isn't connected to an account - Facebook Forum
The account that owns the email address you entered has been disabled. - Facebook 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

i can't enter to my account facebook

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

my facebook hacked and disabled

Can't login to Facebook attempted too many code entries

what does a disabled email address mean?

Similar discussions

Subscribe To Our Newsletter!