Problem when format date option

Closed
NEEL - Nov 30, 2015 at 04:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 30, 2015 at 11:09 AM
Hello,
I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the option "Mar-01" the result i got is "17/07/15" and "Jan-15" respectively. Plz. give me solution its very urgent.

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 30, 2015 at 11:09 AM
Hi Neel,

Seems to me that you only slected the cell with "01/07/2015" before applying format, where you need to select all cells which you want to apply the format to.

Best regards,
Trowa
0