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


--
tyrone

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" <tyrone.29r5ig@news.excelbanter.com> wrote in message
news:tyrone.29r5ig@news.excelbanter.com...
>
> 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

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

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

"Jon Quixley" <Jon.Quixley.29r7fc_1150896004.0771@excelforum-nospam.com>
wrote in message
news:Jon.Quixley.29r7fc_1150896004.0771@excelforum-nospam.com...
>
> 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
>

"tyrone" <tyrone.29r5ig@news.excelbanter.com> wrote in message
news:tyrone.29r5ig@news.excelbanter.com...
>
> 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

tyrone

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

Tools>Options>International.

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 <tyrone.29r5ig@news.excelbanter.com>
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