View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
zhj23 zhj23 is offline
external usenet poster
 
Posts: 60
Default convert percentage to text

Thanks. JE

"JE McGimpsey" wrote:

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?