I'ved created a macro in Excel that I use to convert column number format to Text so the number format does not change after copy/past from a text file:
Sub ConvertBitColumn()
' ConvertBitColumn Macro
' This macro converts 3rd column of the worksheet to Text.
Dim sht As Worksheet
Set sht = ActiveSheet
sht.Columns(2).NumberFormat = "@"
End Sub
The code works fine, but the column in questin shows some green at the left hand corner for some cells, is there a way to get rid of it, or it is normal? Thanks for responding.
Amy
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…