Ask Your Question
0

Creating a PDF from screen which has some hidden rows and columns.

asked 2018-08-15 02:03:07 +0100

syncopat gravatar image

I created a csv file from a vendors database on Windows 10 from a Chrome browser. When I opened the file all was fine and good. The date field populated in American format mm/dd/yyyy and since there were many records from the same day it was easy to analyse, edit whatever. However, the vendor had some issues with Chrome and as a result when I wanted to create a new csv file it would not let me. So I went to Microsoft Edge and was able to download the csv file. When I opened the file it populated the date filed in the Canadian format of dd/mm/yyyy. I am Canadian but it would be nice to have consistency and since I was used to the American format I would like to know how to resolve this issue. For example, my file shows a date as 08/04/2018 which corresponds to April 8. How do I change that to show the same date but to look as follows: 04/08/2018

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-08-15 04:36:19 +0100

m.a.riosv gravatar image

Open a new file, and change the language for default cell style to English (USA), insert the csv file with Menu/Sheet/Insert sheet for file, marking the link option, to update data from csv use Menu/Edit/Link to external files.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-15 02:03:07 +0100

Seen: 24 times

Last updated: Aug 15 '18