Excel, talk to me in Numbers, not Korean!
September 29, 2008 10:30 AM   Subscribe

Excel Language Issue: Why is it speaking Korean when I want English numbers?

Asking for a friend: I work in an English speaking environment, but feel more comfortable working in Korean, so I have both Korean and English languages activated in Windows.

For some reason today, when I type, for example "07-08" to represent the years 2007 & 2008, it translates it into a date, in Korean. Usually, I'd right click > Cell > Number type "general number". Except - this cell is ALREADY set to "General Number". So - why is it insisting on using date format?
posted by anonymous to Computers & Internet (1 answer total)
 
When a cell is set to the General format, it formats it based on a "guess". Since "07-08" looks like a date format, it switches it to Date. If you want "07-08" in that cell, either change the format to Text and then hit F2 to re-evaluate it or put a single quote in front of it like '07-08.
posted by junesix at 10:54 AM on September 29, 2008


« Older Rape records from early US history   |   Thats where you wanna go to get away from it all Newer »
This thread is closed to new comments.