Problem when format date option

Closed
NEEL - Nov 30, 2015 at 04:12 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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.

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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