How to remove the comma of currency number

1. Set cell format to text. Whatever you enter is what you want.

2.

Take a look at the values in the setting cell format. The thousand separator will be used, and the check in front will be cancelled

3. val.replace(/,/g,'&# 39;); (/ What's in it is what you need to replace /,'the replaced thing can be empty ') (g means the whole situation

4.

1. Open our excel file, you can see that the operation of comma to text appears in the cell

5. Since you can replace, replace with 0000; Good luck.

6. Select the data area
right click & gt; Format Cells & gt; Digital & gt; Value, remove the check in front of the "use thousand separator" option, OK

8. Use Ctrl + H to replace all commas with single quotation marks in English

10. You should be talking about the single quotation mark in front of a number. This kind of single quotation mark is added only when you input a long string of numbers. Otherwise, the number will not be displayed. When you input the single quotation mark, you need to input the number again when the input method is English, so that only the number will be displayed instead of the single quotation mark