Commas where decimals should be
 

Hi all,

My excel worksheets have started placing commas where decimal stops should be, such as in currencies and numbers with decimal places. Does anyone know how to stop this occuring?

Many thanks,
Ty

Commas where decimals should be
 

Look at the Regional Settings in the Control Panel (not Excel).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tyrone" wrote in message
...

Hi all,

My excel worksheets have started placing commas where decimal stops
should be, such as in currencies and numbers with decimal places. Does
anyone know how to stop this occuring?

Many thanks,
Ty


--
tyrone

Commas where decimals should be
 

Hi Tyrone,

This usually happens when the system settings have been altered for
whatever reason.
Go to START/Settings/Control Panel and check that Regional and Language
options are set the way you want them - A lot of European countries use
the comma where the UK and US uses a decimal point and vica-versa.

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=554021

Commas where decimals should be
 

"tyrone" wrote in message
...

Hi all,

My excel worksheets have started placing commas where decimal stops
should be, such as in currencies and numbers with decimal places. Does
anyone know how to stop this occuring?

Regional settings in Windows?
--
David Biddulph

Commas where decimals should be
 

Not just in Europe; also in Quebec, Canada
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jon Quixley"
wrote in message
...

Hi Tyrone,

This usually happens when the system settings have been altered for
whatever reason.
Go to START/Settings/Control Panel and check that Regional and Language
options are set the way you want them - A lot of European countries use
the comma where the UK and US uses a decimal point and vica-versa.

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile:
http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=554021

Commas where decimals should be
 

tyrone

Usually caused by Regional Settings, but another spot to check.

ToolsOptionsInternational.

If "use system separators" is unchecked you can swap the comma and decimal dot.

Some wag may have done this to you.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 12:40:34 +0100, tyrone
wrote:


Hi all,

My excel worksheets have started placing commas where decimal stops
should be, such as in currencies and numbers with decimal places. Does
anyone know how to stop this occuring?

Many thanks,
Ty