Hi All..
I have a data upload in CSV file that I need to play around with later...
The problem I'm facing is that the dates are formating 2 different ways...
Sample.png
any idea how can I change the settings so it will format in to notmal day/month/year time format? and not PM / AM one?
when you import CSV are you specifying the date field - rather than just double click on the CSV file - try open - it should open the wizard
then you can specify the column format type
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
It looks like everything with a day < 13 is formatting differently from days that are > 12. This is because there are only 12 months in the year.
This is commonly due to differences between MDY and DMY formatting. I have a feeling that you formatted the dates improperly.
As etaf suggested, make sure that you chose whether the dates are formatted as MDY or DMY while in the Text to columns steps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks