View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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