How do I change the character separating thousands or decimals on.
 

Excel 2000?

My decimals are now a comma (,) instead of a dot (.) & vice-versa.

How do I change the character separating thousands or decimals on.
 

Not an Excel setting, but Windows Control Panel Regional Options
--
David Biddulph

"khair" wrote in message
...
Excel 2000?

My decimals are now a comma (,) instead of a dot (.) & vice-versa.

How do I change the character separating thousands or decimals on.
 

Although you can override within Excel by going
ToolsOptionsInternational tab and unchecking "Use System Separators"
and set your own Decimal and Thousands separators.

Richard


On 2 Mar, 07:45, "David Biddulph" <groups [at] biddulph.org.uk wrote:
Not an Excel setting, but Windows Control Panel Regional Options
--
David Biddulph

"khair" wrote in message

...



Excel 2000?

My decimals are now a comma (,) instead of a dot (.) & vice-versa.- Hide quoted text -

- Show quoted text -

How do I change the character separating thousands or decimals on.
 

Altho missed that that was xl2000 :-(

Richard


On 2 Mar, 08:40, "RichardSchollar"
wrote:
Although you can override within Excel by going
ToolsOptionsInternational tab and unchecking "Use System Separators"
and set your own Decimal and Thousands separators.

Richard

On 2 Mar, 07:45, "David Biddulph" <groups [at] biddulph.org.uk wrote:



Not an Excel setting, but Windows Control Panel Regional Options
--
David Biddulph

"khair" wrote in message

...

Excel 2000?

My decimals are now a comma (,) instead of a dot (.) & vice-versa.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -