How to convert thousand commas to decimal points or vice versa in Excel?
When you are working at some international audit, you may have encountered this problem, to convert thousand commas to decimal points or vice versa in Excel worksheet. Do you have any tricks on solving this task?
 |
 |
 |
Convert all commas to decimal points with Option
Convert all commas to decimal points with Option
If you have a list of numbers as below screenshot shown, now you want to convert the commas (the thousands separator ) to decimal points, and the decimal points (decimal separator) to commas, you can use the Option function.
Click File > Options, then in the Excel Options dialog, click Advanced from left pane, then in the right section, the Editing options group, uncheck Use system separator, then type comma into the Decimal separator box to instead of the decimal point, and type decimal point to the Thousand separator box to replace the comma.
 |
|
 |
Click OK.
Best Office Productivity Tools
Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel (Full-Featured 30-Day Free Trial)
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! (Full-Featured 30-Day Free Trial)
