| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Missing commas
I have a workstation using Excel 2000. Since installing XP Service Pack 2,
Excel does not show the commas used to show thousands. For example, the number shows as 47 911 instead of 47,911. Any ideas what would cause this or how to fix it? |
|
#2
|
|||
|
|||
|
Could be two places..
1) In Excel, Tools | Options | International. Check the Thousands separator.By default this is set to "Use System Separators" 2) From Windows Control Panel, Regional and Language Options Customise if needed. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Steve Mock" <Steve wrote in message ... I have a workstation using Excel 2000. Since installing XP Service Pack 2, Excel does not show the commas used to show thousands. For example, the number shows as 47 911 instead of 47,911. Any ideas what would cause this or how to fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| PivotTable toolbar missing? | Setting up and Configuration of Excel | |||
| Removing commas | Excel Worksheet Functions | |||
| When converting an .xls file to .csv I get too many commas at the. | Excel Discussion (Misc queries) | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
Linear Mode
