譬如字符串是“¥123,45.00”我现在要截取得到12345.可是现在用Mid(“¥123,45.00”, InStr(a, "¥") + 1)只能截取到123.遇到逗号就停止了,请求大家帮帮忙吧!
right("¥123,45.00",len("¥123,45.00")-1)
a="¥123,45.00"Mid(a, InStr(1,a, "¥") + 1)
aa = Format("¥123,45.00", "0") 不就好啦!!