Professor Excel
thousands, decimal, separator, change, excel, powerpoint, thinkcell

Change Thousands & Decimal Separators in Excel, PowerPoint and ThinkCell

Sometimes you don’t want the comma “,” as a thousands separator, but rather a full stop “.”. Or you don’t want the full stop as the decimal separator. Changing these two separators in Office is easy: You can either do it system-wide or override the system settings.


thousands, millions, excel, display, cell, format

Thousands or Millions in Excel: How to Change the Number Unit

When you calculate with large numbers, you might want to only show the values as thousands or millions. Unfortunately, Excel doesn’t offer such option with a single click.