| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| I need to change the path of the linked files - thousands of them. | Excel Discussion (Misc queries) | |||
| How do I change thousands to intergers on my spreadsheet? | Excel Discussion (Misc queries) | |||
| Change character while copy | Excel Worksheet Functions | |||
| change 5523.44 to 552344 no decimals | Excel Worksheet Functions | |||
Hybrid Mode
