convert percentage to text
One (simplistic) way:
Dim bPercentFormat As Boolean
bPercentFormat = CBool(InStr(Range("A1").NumberFormat, "%"))
MsgBox bPercentFormat
In article ,
zhj23 wrote:
Question: how can I evaluate in VBA whether a cell is in simple numeric or
percentage numeric form?
|