Determinging the Format of a cell

  • Thread starter Thread starter Ric Payne
  • Start date Start date
R

Ric Payne

Is there a way to determine whether a cell has been formatted as a PCT%?
Thanks in advance for your help with this.
 
Ric Payne said:
Is there a way to determine whether a cell has been formatted as a
PCT%? Thanks in advance for your help with this.
Click to expand...

Hi Ric,

Try the CELL function:

=IF(CELL("format",A1)="P0","Percent_0","Other")

HTH,

Alan.
 
Ric,

Alternatively, you can do it without needing to know all the names of the
formats that might be applied, which is probably more flexible. This picks
up any format ending iwth a percentage.

Function IsPercentFormat(rngCell as range) as boolean
Dim strFormat as String
'note no error traps for multiple cell range
strFormat= rngCell.NumberFormat
If (InStr(1, strFormat, "%", 1)) > 1 Then IsPercentFormat=True
End Function
 
Back
Top