Language

[sharutmey]

My computer only recognized the symbol (,) as a decimal point. Thus in a
formula I have to type: 1,6 for the number l.6 . This is how a decimal
point is represented in Spanish, but the English (United States) is selected
and is the Default. Is there anywhere else the Spanish can be leaking over?

 

[Mike H]

Hi,

By default Excel uses the Windows settings for this so change those to what
you want using Control Panel|Regional & Language settings or you can override
them by going to

tools|Options|international and un-checking use system seperators and then
entering the seperators you want.

Mike

 

[FC]

Hi sharutmey, just a correction for you and all readers : the decimal point
in spanish is the same as in english ( . ) Thanks

 

[JE McGimpsey]

Hi FC, a further correction for you: use of "." or "," as a decimal
separator depends more on the country, not the language.

Many, if not most Spanish-speaking countries use "," (including Spain).


See http://en.wikipedia.org/wiki/Decimal_point

 

[FC]

Yes ! exactly what I meant to mean ( is this correct english ?). Thank you
for clear it better JE McGimpsey.