how to change the below data

  • Thread starter Thread starter keerthyV
  • Start date Start date
K

keerthyV

i entered my dates as in this format -
19/08/1984,(DD/mm/yyyy)
20/04/1984
10/05/1985
04/08/1985
21/10/1983
23/03/1984
1/01/1986
14/11/1985,

I need it in DD-mmm-yyyy like 19-Aug-1986,20-Apr-1984,..

Please help me,
 
If you want to change the display format in cells, the command is Format/
Cells...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check range 1
Lookup between two dates 3
Find Period Date? 5
Formatting time 2
Conditional Formatting - Dates 2
Find within Date Range 4
Change from mm/dd/yy to yy/mm> 3
Error in chart with 2 different series... 1

Back
Top