| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - 2 decimal places
Is it possible to restrict data entry to numercial values to 2 decimal places
- perhaps using data validation? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - 2 decimal places
Custom type with a formula of
=IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TR UE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - 2 decimal places
Superb.
But I need to restrict data entry to only numercial values greater than zero to 2 decimal places - I can't seem to amend the formula to do this. "Bob Phillips" wrote: Custom type with a formula of =IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TR UE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - 2 decimal places
=IF(ISNUMBER(G1),IF(G10,IF(NOT(ISNUMBER(FIND(".", G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Superb. But I need to restrict data entry to only numercial values greater than zero to 2 decimal places - I can't seem to amend the formula to do this. "Bob Phillips" wrote: Custom type with a formula of =IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TR UE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - 2 decimal places
Genius - works perfectly. Thanks very much
"Bob Phillips" wrote: =IF(ISNUMBER(G1),IF(G10,IF(NOT(ISNUMBER(FIND(".", G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Superb. But I need to restrict data entry to only numercial values greater than zero to 2 decimal places - I can't seem to amend the formula to do this. "Bob Phillips" wrote: Custom type with a formula of =IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TR UE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darren L" wrote in message ... Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with a fixed amount of decimal places | Excel Worksheet Functions | |||
| Data validation with a fixed amount of decimal places | Excel Worksheet Functions | |||
| Limiting Validation entries to 2 places after a decimal | Excel Discussion (Misc queries) | |||
| Aligning data with varying decimal places | Excel Discussion (Misc queries) | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
![Darren L[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
