Validation numeric and text

[BNT1 via OfficeKB.com]

Hi

Is it possible to validate a cell that will only except numeric values, and
only the letter "H"? My idea, is that when the guy is on holiday, "H" can be
entered instead of the numeric value "0"

Thanks in advance

Regards

 

[JE McGimpsey]

One way:

Allow: Custom
Formula: =OR(ISNUMBER(A1),A1="H")

 

[T. Valko]

So you want the cell to accept *either* a number or the letter H?

Try this:

Data>Validation
Allow>Custom
Formula: =OR(ISNUMBER(A1),A1="H")

 

[BNT1 via OfficeKB.com]

thanks guys

So you want the cell to accept *either* a number or the letter H?

Try this:

Data>Validation
Allow>Custom
Formula: =OR(ISNUMBER(A1),A1="H")

Hi

[quoted text clipped - 7 lines]

Regards

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

thanks guys

So you want the cell to accept *either* a number or the letter H?

Try this:

Data>Validation
Allow>Custom
Formula: =OR(ISNUMBER(A1),A1="H")

Hi

[quoted text clipped - 7 lines]

Regards