执行mysql的语句的时候,输出结果是[Decimal'69659')],然后插入到wps表格里的时候就是¥69659.00,
这是语句:select count from (select sum(a.num) as count from (SELECT createtime,b.drp_id,count(*) as num FROM t_sapd_norprice a right JOIN online_app_code b on a.storecode=b.drp_id WHERE createtime>=CURDATE() GROUP BY b.drp_id order by count(*)) a) b
表格的格式已经全都改成了文本,但是插入的时候还是带¥,求问怎么才能把¥去掉