Decimal Points and comma separators
 

I work with very exact numbers, sometimes up to 7 significant figures after
the decimal point, and I copy/paste this numbers from another program. My
problem is that my comma separator appears as a decimal point and my decimal
point is a comma, and sometimes the people i hand out this info to, get all
mixed up and are always calling me back.... How can i change my number format
so that my decimal point appears as a decimal point and not a comma? or, how
do i make my thousand separator be a comma and not a decimal point? or, How
can i solve them both?

Decimal Points and comma separators
 

This is a windows setting.

Control panel|regional settings|regional options tab|customize button

Change the decimal and digit grouping symbols.

Miguel Gamez wrote:

I work with very exact numbers, sometimes up to 7 significant figures after
the decimal point, and I copy/paste this numbers from another program. My
problem is that my comma separator appears as a decimal point and my decimal
point is a comma, and sometimes the people i hand out this info to, get all
mixed up and are always calling me back.... How can i change my number format
so that my decimal point appears as a decimal point and not a comma? or, how
do i make my thousand separator be a comma and not a decimal point? or, How
can i solve them both?

--

Dave Peterson

Decimal Points and comma separators
 

You must be sharing this info on paper, right?

I would have guessed that if you shared the file, then the recipient's windows
setting would have done the conversion without you knowing.

Miguel Gamez wrote:

I work with very exact numbers, sometimes up to 7 significant figures after
the decimal point, and I copy/paste this numbers from another program. My
problem is that my comma separator appears as a decimal point and my decimal
point is a comma, and sometimes the people i hand out this info to, get all
mixed up and are always calling me back.... How can i change my number format
so that my decimal point appears as a decimal point and not a comma? or, how
do i make my thousand separator be a comma and not a decimal point? or, How
can i solve them both?

--

Dave Peterson