Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 "sharutmey" wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi sharutmey, just a correction for you and all readers : the decimal point
in spanish is the same as in english ( . ) Thanks "sharutmey" wrote: 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? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 In article , FC wrote: Hi sharutmey, just a correction for you and all readers : the decimal point in spanish is the same as in english ( . ) Thanks |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes ! exactly what I meant to mean ( is this correct english ?). Thank you
for clear it better JE McGimpsey. "JE McGimpsey" wrote: 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 In article , FC wrote: Hi sharutmey, just a correction for you and all readers : the decimal point in spanish is the same as in english ( . ) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
OS language and Office language conflicts | Excel Worksheet Functions | |||
LANGUAGE BAR | Charts and Charting in Excel | |||
How can I programatically change the language in the language bar? | Excel Discussion (Misc queries) | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) |