Commas where decimals should be

[tyrone]

Hi all,

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

Many thanks,
T

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Jon Quixley]

Hi Tyrone,

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

Cheers
Jo

 

[David Biddulph]

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?

 

[Bernard Liengme]

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

"Jon Quixley" <[email protected]>
wrote in message
news:[email protected]...

 

[Gord Dibben]

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