Previous Topic Next Topic

Date formate

Solved/Closed
anu - May 6, 2010 at 02:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 8, 2010 at 11:22 AM


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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 6, 2010 at 07:45 AM
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
Gaurav
May 8, 2010 at 10:07 AM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 8, 2010 at 11:22 AM
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

Similar discussions

How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
Excel format
D -
sheryljohnson -

1 response
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response