ExcelBanter - looking for true result if number is a %

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - looking for true result if number is a % (https://www.excelbanter.com/excel-programming/415756-looking-true-result-if-number-%25.html)

Roger on Excel

looking for true result if number is a %

i would like an adjacet cell read TRUE if the number in the adjacent cell is
a percentage% format.

Can anyone help?

Thanks,

Roger

Rick Rothstein \(MVP - VB\)[_2590_]

looking for true result if number is a %

Give this formula a try...

=LEFT(CELL("format",A1))="P"

Rick

"Roger on Excel" wrote in message
...
i would like an adjacet cell read TRUE if the number in the adjacent cell
is
a percentage% format.

Can anyone help?

Thanks,

Roger

All times are GMT +1. The time now is 05:10 PM.