Date format

Closed
Ranjithv Posts 1 Registration date Wednesday February 19, 2014 Status Member Last seen February 19, 2014 - Feb 19, 2014 at 05:34 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Feb 20, 2014 at 12:53 AM
Hi,

can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............
Related:

2 responses

Blocked Profile
Feb 19, 2014 at 09:22 AM
Ok, I hope this helps you, see below:


Notice, it will work both ways:

Have fun!

"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
0
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Feb 19, 2014 at 01:10 PM
Hi

If that is a proper date, try: CTRL + # this works for my local time.
0
Blocked Profile
Feb 19, 2014 at 01:35 PM
I just tried your suggestion Keven, nothing doing. No changes on an empty cell, no changes on a cell containing text, no changes on cell containing dates, no changes on a cell containing formulas.

Are you certain your worksheet doesnt have a macro recorded. It it does, then share the macro behind the key stroke. :)
0
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Feb 20, 2014 at 12:53 AM
As I said it works for my region.
0