This is an live action short video from Russia (I believe). It's in the style of a first person shooter game.
Monday, 15 April 2013
Tuesday, 5 February 2013
How to stop Excel from automatically splitting a CSV
One of the annoying features added to Excel is that when you open a file with csv extension it automatically parses the file on the "," and butchers your file. This is annoying if the file uses another character to split or contains German numbers which use a comma for the decimal etc. So how do you fix this?
1) Open Excel (dont double click on the CSV)
2) Go to "Data" -> "Get External Data from Text"
3) Select the CSV file
4) Click "Import"
5) Go through the wizard and specify the delimiter and that all fields are text not numebrs etc
6) You are done.
Subscribe to:
Posts (Atom)