Ms excel query

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

08 November 2014 In a cell ythe date was keyedin as 19500803 - how to convert this date to 03-08-1950 please answer me

Ganeshbabu K (Expert)
Follow

08 November 2014 1)Right click

2)click on format

3)under category choose date

4)alter the format as u need and click okay

Damodaran (Expert)
Follow

08 November 2014 Try this; =right(Cell ref,2)&"-"&mid(cell ref,5,2)&"-"&left(cell ref,4)

@VaibhavJ (Expert)
Follow

09 November 2014 Hi

Select whole range, then select data text to column option. Press next and then select date and ymd option and press ok.

Thanks

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Unanswered Queries

view all classess