Date formate

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-


hi
i have date formate in dd\mm\yyyy & dd-mm-yyyy.
i need all the dates in same formate exp.

3/4/2010
13-04-2010

i need

3/4/2010
13/04/2010

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Lets say your dates are in column A

Select Column A
Go to Data, and choose Text to column
choose delimited
click on next
remove all checks
click on next
choose data and pick the right format for your data. This is the format in which the data current appears. It seems you would be using DMY (date, month year) and click finish
0
THANKS A LOT RIZVISA .... you have solved my problem...

jst small change i have done i have select MDY (Month, date , year) format and after that all automatically come in DMY format ...

dnt know why that time when i select DMY that was not resolving my Problem

but THANKS... YOU HAVE Resolve my PROBLEM Thanks A LOT Dear
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Gaurav , DMY or MDY or other format you choose, based on the date that in the data. In the original question, the date was 13/04/2010 which showed that in data date is in DMY format. Well as long as issue is resolved. Have you not heard saying Eat mangoes, dont count tree. :D
0