All Questions
4
questions
0
votes
0
answers
70
views
Excel treats a date in format (dd-MMM-yy) differently if typed or pasted
This was discovered when opening a file in CSV format that has a column of dates in the format dd-MMM-yy (e.g 20-FEB-24). When opening this file in Excel (Excel 365 desktop) if the 2 year value is <...
- 101
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
- 11
0
votes
0
answers
3k
views
Stop Excel from re-interpreting date format on re-opening CSV
I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
- 1
2
votes
1
answer
1k
views
Formatting date in csv for conversion to QIF
I am hoping someone might have a solution that will allow me to save a date format in csv as dd/mm/yy. I am converting bank transactions from csv to qif - but when I import into my accounting package, ...
- 21