Validation numeric and text
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

Validation numeric and text
 

One way:

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


In article <76a66fe54efa3@uwe, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

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

Validation numeric and text
 

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

Try this:

DataValidation
AllowCustom
Formula: =OR(ISNUMBER(A1),A1="H")


--
Biff
Microsoft Excel MVP


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:76a66fe54efa3@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

Validation numeric and text
 

thanks guys

T. Valko wrote:
So you want the cell to accept *either* a number or the letter H?

Try this:

DataValidation
AllowCustom
Formula: =OR(ISNUMBER(A1),A1="H")

Hi

[quoted text clipped - 7 lines]

Regards

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

Validation numeric and text
 

You're welcome!

--
Biff
Microsoft Excel MVP


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:76afb532db1be@uwe...
thanks guys

T. Valko wrote:
So you want the cell to accept *either* a number or the letter H?

Try this:

DataValidation
AllowCustom
Formula: =OR(ISNUMBER(A1),A1="H")

Hi

[quoted text clipped - 7 lines]

Regards

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1