Working in multiple languages/locales

Question

Is there any way to set the locale I want to use for a file in Excel?
This is my situation:
I normally work in multiple languages, which means different numbers, currency, dates representations, etc.
The worst is when I'm copy pasting data from language specific sources and I have to manually fix it.
Is there any way to tell Excel that a certain file is going to be worked in ES_es and another one in EN_us?
The only solution I find everywhere is to change the system locale, I'd like to avoid that.

harrymc · Answer

Try a program such as PureText to remove the formatting information
from the clipboard.
This might remove the language-dependent settings from the data currently
in the clipboard.
Better check that the copied data is correct, even if this seemed to work.

Reddy Lutonadio · Answer

For dates and times, you can try to select the cells that must be in another locale, then format them. On the Home tab, click on Number, then change the Date or Time locales.

Working in multiple languages/locales

2 Answers

Add your own answers!

Ask a Question