Determinging the Format of a cell

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.
 
A

Alan

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.
 
R

Robin Hammond

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Want to test if Full Name is NOT Present in document 0
Excel does not accept text format! 0
Sum cells with specific format 6
Replacing a phrase with carriage returns 1
Table of content - format does not get saved 2
ASK Field Formatting 1
Paste to excel from word - auto format problem 1
Copy addition formula of non-consecutive horizontal cells 2

Top