Converting date to different Format

A

AhujaA

Joined
May 14, 2012
Messages
21
Reaction score
0
Hi,
My data is in numbers like 1/31/1970 and is displayed(format) like 31 Jan 70, and I want it to be in a format of Jan1970. Any suggestions how can I do it?

Thanks
 
If it's Excel, select the cells you want to format this way, then right click on them and go to Format Cells. On the number tab, click on Custom in the bottom left. Then, in the line to the right of "Type:" type mmmyyyy and that should do it.
 
Back
Top