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

Is this your account? we couldn't find an account that matches what you entered, but found one that closely matches.
Hi5 old account - Guide
Gmail login another account - Guide
If we add close friends story to highlight everyone can see that - Instagram Forum
How to transfer free fire account to another google account - Guide
Reactivate my Hi5 account - Internet & Social Networks 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

Accounts not able to message me unless I follow them

yahoo account deactivated, but i still have access.

finding my facebook account

Find Facebook account

Recover deleted Yahoo account after 4 years

Similar discussions

Subscribe To Our Newsletter!