Pack

In the Spanish format "10.000" is ten thousand. If I I copy and paste this text in another cell, the "." disappears. How can I ensure the format is not lost or, even better, that a string containing numbers is formatted as a number, but with the Spanish format? Thanks.