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
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!