RE: Count number of digits (Numbers)
- From: JohnUK <JohnUK@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 28 Nov 2008 09:08:03 -0800
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
- References:
- Count number of digits (Numbers)
- From: JohnUK
- RE: Count number of digits (Numbers)
- From: Mike H
- Count number of digits (Numbers)
- Prev by Date: How can I display an Excel Report with animation like PowerPoint
- Next by Date: RE: Count number of digits (Numbers)
- Previous by thread: RE: Count number of digits (Numbers)
- Next by thread: RE: Count number of digits (Numbers)
- Index(es):
Relevant Pages
|
