R Roger on Excel Aug 16, 2008 #1 i would like an adjacet cell read TRUE if the number in the adjacent cell is a percentage% format. Can anyone help? Thanks, Roger
i would like an adjacet cell read TRUE if the number in the adjacent cell is a percentage% format. Can anyone help? Thanks, Roger
R Rick Rothstein \(MVP - VB\) Aug 16, 2008 #2 Give this formula a try... =LEFT(CELL("format",A1))="P" Rick