1
vote
0answers
20 views

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...
0
votes
1answer
240 views

Excel: How can I replace a short string of characters with one character?

So, I keep a spreadsheet of all of my bowling scores and how I do on each frame. To show that I got a split, I use "#s", where # is how many pins I knocked over, but I want to replace all of these ...
17
votes
4answers
79k views

How to set character encoding when opening Excel

Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)? I When I try to open a csv file encoded in Japanese ...