Regarding date format

[Allwinv]

Hi Excel experts,

In one of the Cell i have a data like 13/6/2018 2:38 PM. I want to change the data to 13-June-2018 and ignoring other data. Can you please help on this.

And in one column the data 2 is there. I want add letter P in the front. ie) P2. Please suggest.

Thanks.

 

[Michael M]

R Click the cell>>format cells>>Number>>Custom and then type in the description dd-mmm-yyyy

 

[Allwinv]

Thank you so much. It is working now.

Regarding the 2nd question can you please help.

one column the data 2 is there. I want add letter P in the front. ie) P2. Please suggest.

Thanks.

 

[Michael M]

VBA or formula ??
If you want a formula, in an adjacent column, say Col C, put

="P" & B1

Drag down as required