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,

keerthyV;254679 Wrote:
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,

Select the values
Right Click
Select Format
Custom format
Enter dd-mm-yyy
OK

( if it doesn't work check if what you see are real dates or text
looking like dates)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71099

If you want to change the display format in cells, the command is Format/
Cells...
--
David Biddulph

"keerthyV" wrote in message
...
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,