| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of digits (Numbers)
Hi, I am after a formula that can tell me that a string of numbers doesnt
equal to six digits if that makes any sense. Reason: Each cell is picking up numbers from other cells, but if the total number of digits doesnt equal to six (maybe more or less), its an error. Data Validation isnt any good for me in this instance. Any help greatly appreciated. John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of digits (Numbers)
Hi,
=LEN(A1)<=6 Mike "JohnUK" wrote: Hi, I am after a formula that can tell me that a string of numbers doesnt equal to six digits if that makes any sense. Reason: Each cell is picking up numbers from other cells, but if the total number of digits doesnt equal to six (maybe more or less), its an error. Data Validation isnt any good for me in this instance. Any help greatly appreciated. John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of digits (Numbers)
Fantastic - Thank you very much Mike
Regards John "Mike H" wrote: Hi, =LEN(A1)<=6 Mike "JohnUK" wrote: Hi, I am after a formula that can tell me that a string of numbers doesnt equal to six digits if that makes any sense. Reason: Each cell is picking up numbers from other cells, but if the total number of digits doesnt equal to six (maybe more or less), its an error. Data Validation isnt any good for me in this instance. Any help greatly appreciated. John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of digits (Numbers)
=LEN(A1)< 6 would be TRUE if there are more or less than 6 digits and FALSE
if the length is 6. "JohnUK" wrote: Hi, I am after a formula that can tell me that a string of numbers doesnt equal to six digits if that makes any sense. Reason: Each cell is picking up numbers from other cells, but if the total number of digits doesnt equal to six (maybe more or less), its an error. Data Validation isnt any good for me in this instance. Any help greatly appreciated. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of digits in a cell | Excel Worksheet Functions | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| sorting numbers with an irregular number of digits | Excel Discussion (Misc queries) | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Count if number between two numbers in Excel? | Excel Worksheet Functions | |||
Linear Mode
