All Questions
7
questions
1
vote
1
answer
4k
views
How to retain date format from raw csv file as is when opened via MS-office Excel?
I have data given to us via email/hard drive which has randomized future dates (ex: 21/02/2200) in multiple formats.
During data transfer 1st mail, the file sent has date format in DD/MM/YYYY.
...
- 149
0
votes
1
answer
40
views
Excel 2013 showing only certain dates in a European format
I have a CSV file where all dates are in a U.S. format (dd/mm/yyyy):
However, Excel shows some - but not all - of the cells in mm.dd.yyyy format:
This is on a server in Germany.
Does anyone know ...
0
votes
1
answer
2k
views
How to display US format date time in csv file in UK format in Excel 2010?
I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
- 1,285
1
vote
2
answers
3k
views
Changing DateTime format in multiple CSV files
I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...
- 125
0
votes
2
answers
989
views
How to get Excel to save date fields as displayed
I have data that has date-time values that I need to convert to a different format. I have created an Excel formula that concatenates the string into exactly the format I need. I currently have the ...
8
votes
13
answers
110k
views
How to stop Excel Treating US dates as UK dates?
I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
- 260
3
votes
1
answer
5k
views
How to add time duration column total from Skype Call History CSV file in Excel 2010?
How to add time duration column total from Skype Call History CSV file in Excel 2010?
These are my exact steps on how to set up my Excel spreadsheet.
How to import Skype Call History CVS in Excel ...
- 1,061