| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text treated as a numeric value? | Excel Discussion (Misc queries) | |||
| A validation rule on Alpha and Numeric characters | Excel Worksheet Functions | |||
| numeric value disply in text | Excel Discussion (Misc queries) | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Text to Numeric | Excel Worksheet Functions | |||
Linear Mode
