ExcelBanter - test is text, not number..

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - test is text, not number.. (https://www.excelbanter.com/excel-discussion-misc-queries/150206-test-text-not-number.html)

nastech

test is text, not number..

hi, trying to fix a conditional format to if not empty, but not a number. is
there a way to test for that? along lines of:

=IF(AND(A1<"",A1<number),..

thanks.

Pete_UK

test is text, not number..

You probably want something like:

.... NOT(ISNUMBER(A1)) ...

Hope this helps.

Pete

On Jul 14, 1:32 am, nastech wrote:
hi, trying to fix a conditional format to if not empty, but not a number. is
there a way to test for that? along lines of:

=IF(AND(A1<"",A1<number),..

thanks.

Max

test is text, not number..

=IF(AND(A1<"",A1<number),..

For CF, this might suffice:
=AND(A1<"",ISTEXT(A1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nastech" wrote:
hi, trying to fix a conditional format to if not empty, but not a number. is
there a way to test for that? along lines of:

=IF(AND(A1<"",A1<number),..

thanks.

All times are GMT +1. The time now is 02:39 PM.