"Ric Payne" wrote in message
om...

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


Hi Ric,

Try the CELL function:

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

HTH,

Alan.