208 reputation
126
bio website
location
age
visits member for 3 years, 9 months
seen 17 hours ago

Jan
16
awarded  Yearling
May
14
comment How do you save a LibreOffice Writer file as plain text?
It seems that the default is not UTF-8 but ANSI so here in Japan the encoding defaults to the legacy encoding: Shift-JIS. In the US, I guess it would be cp-1252 (Latin 1).
Apr
22
awarded  Scholar
Apr
22
accepted How to set character encoding when opening Excel
Apr
22
comment How to set character encoding when opening Excel
Sorry, I didn't check back until now. The "Data"->"From Text" approach works fine with xl2007 and xl2010. Not obvious but it works.
Feb
13
awarded  Nice Question
Jun
11
awarded  Famous Question
Jan
7
awarded  Notable Question
Oct
13
awarded  Popular Question
May
20
revised How can I make my multi-monitor setup wrap around?
deleted 1 characters in body
May
13
awarded  Editor
May
13
revised How to set character encoding when opening Excel
added 25 characters in body
May
10
comment How to set character encoding when opening Excel
This didn't work. My system is a Japanese system and so SHIFT-JIS is already set here as the default. But, I have my default editing language set for English (with Japanese also added). If I set the default editing language to Japanese, then the SHIFT-JIS csv file will open correctly. But this is messy. What if the file was some other encoding (e.g. Korean, Chinese)? What I really need is a place to set the encoding of the file (like I can in Open Office Calc).
May
10
comment How to set character encoding when opening Excel
2003 or 2010 (I skipped 2007)
May
8
awarded  Student
May
8
asked How to set character encoding when opening Excel
Dec
2
awarded  Teacher
Dec
2
answered Can I upgrade Windows 7 32bit to 64bit?
Dec
2
answered How can I make my multi-monitor setup wrap around?