Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determinging the Format of a cell
Is there a way to determine whether a cell has been formatted as a PCT%?
Thanks in advance for your help with this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determinging the Format of a cell
"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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determinging the Format of a cell
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 -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |