[算表] 請教一個篩選的問題
軟體:office
版本:2007
A列
2000
1000
2000A
1000A
當處于篩選模式,輸入2000,2000和2000A都被篩選出來,請問該如何操作?
我自己試了一下把A列全部轉換成文本格式,但是沒有成功.
如何把A列變成文本,如何給單元格是數字,左上角會帶綠標那種
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 27.38.52.136
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1433056047.A.9FC.html
※ 編輯: yyingx (27.38.52.136), 05/31/2015 16:41:19
→
05/31 16:44, , 1F
05/31 16:44, 1F
→
05/31 16:50, , 2F
05/31 16:50, 2F
→
05/31 16:51, , 3F
05/31 16:51, 3F
→
05/31 16:52, , 4F
05/31 16:52, 4F
→
05/31 16:55, , 5F
05/31 16:55, 5F
→
05/31 16:55, , 6F
05/31 16:55, 6F
→
05/31 16:56, , 7F
05/31 16:56, 7F
→
05/31 17:01, , 8F
05/31 17:01, 8F
So大請看回圈,感覺太慢了,有啥好的方法和建議嗎?
Sub 轉換文本()
Dim i As Integer
a = [e65536].End(3).Row
Range("e4", Range("e" & a)).NumberFormat = "@"
For i = 4 To a
Range("e" & i) = Format(Range("e" & i), "0")
Next
End Sub
※ 編輯: yyingx (27.38.52.136), 05/31/2015 17:35:36
→
05/31 17:45, , 9F
05/31 17:45, 9F
→
05/31 17:46, , 10F
05/31 17:46, 10F
→
05/31 18:22, , 11F
05/31 18:22, 11F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
11
17