Date format [Closed]

Report
Posts
1
Registration date
Wednesday February 19, 2014
Status
Member
Last seen
February 19, 2014
-
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
-
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............

2 replies


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
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Hi

If that is a proper date, try: CTRL + # this works for my local time.
Blocked Profile
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. :)
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
As I said it works for my region.