| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Find and Replace from rows to separation by commas | Excel Discussion (Misc queries) | |||
| Merging Excel data to word, keeps including all decimals on number | Excel Discussion (Misc queries) | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
| Decimals separation by . or , | Excel Discussion (Misc queries) | |||
Linear Mode
