金额添加千分位
regExp(cellValue) {
if (cellValue !== null) {
cellValue = Number(cellValue).toFixed(2); //小数点后两位
cellValue += "";
if (!cellValue.includes(".")) cellValue += ".";
return cellValue
.replace(/(\d)(?=(\d{3})+\.)/g, function ($0, $1) {
return $1 + ",";
})
.replace(/\.$/, "")
}
},
金额去除千分为位
delcommafy(num) {
if (num != undefined) {
num = num.toString();
num = num.replace(/[ ]/g, ""); //去除空格
num = num.replace(/,/gi, '');
return Number(num);
}
},