Ask a question Report

Date entered wrongly

ANJU BIDASARIA - Aug 10, 2017 at 01:15 PM - Latest reply: ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen

- Aug 11, 2017 at 09:06 PM

Excel Ask a question Report

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
Wrong Date and Time in WhatsApp » How-To - Mobile
Generate a list depending on date entered » Forum - Office software
Microsoft Access - Automatically enter the current date » How-To - Access
Wrong PIN entered three times, mobile blocked by PUK code » How-To - Mobile
Do not count if date not entered (Solved) » Forum - Office software

Your reply

Reply to this topic

1 reply

Report Respond to ac3mark

ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Updated by ac3mark on 11/08/17 at 09:09 PM

Thank you

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

Your reply

Reply to this topic

Ask a question