Hi Wes,
Attached herewith is the solution with explanation. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 6:41 AM, Wes wrote:
>
> I've been trying to get some cell validation
Hi Wes
Not too sure what the problem is exactly as I have just used
"Data Validation"
=> "Settings"
=> "Allow " = "Text length"
=> "Data" = "less than or equal to"
=> "Length" = "7"
then tested it on a cell with custom format of "000" and it seems
to be OK.
Let me know how you go if this is
Remember that Excel stores numbers as numbers.
it may DISPLAY them in all variety of things.
For instance, the number 109.123456
Could be SHOWN as:
109.123456
109.12
109.1234560
4/18/1900
2:57:47 AM
4/18/00 2:57 AM
the letter "m"
Each of these LOOK different, but are actually the same numb
Hi Wes,
Try formatting your data as text, then use the following data validation:
=AND(LEN(A1)=7,ISERROR(VALUE(A1))=FALSE)
Regards - Dave.
> Date: Mon, 3 Aug 2009 18:11:25 -0700
> Subject: $$Excel-Macros$$ Data Validation to only allow 7 digit numbers in a
> entire column
> From: wesle
