Results 1 to 14 of 14

Cell Restrictions allow only numbers, no special characters

Threaded View

karimel_romeo Cell Restrictions allow only... 04-22-2015, 12:12 PM
Nisha Dhawan Re: Cell Restrictions allow... 04-22-2015, 01:19 PM
bhenlee Re: Cell Restrictions allow... 04-22-2015, 01:49 PM
Tony Valko Re: Cell Restrictions allow... 04-22-2015, 01:52 PM
Tony Valko Re: Cell Restrictions allow... 04-22-2015, 01:42 PM
bhenlee Re: Cell Restrictions allow... 04-22-2015, 01:46 PM
Nisha Dhawan Re: Cell Restrictions allow... 05-07-2015, 01:56 AM
bhenlee Re: Cell Restrictions allow... 04-22-2015, 01:53 PM
Tony Valko Re: Cell Restrictions allow... 04-22-2015, 01:57 PM
karimel_romeo Re: Cell Restrictions allow... 04-22-2015, 02:10 PM
Tony Valko Re: Cell Restrictions allow... 04-22-2015, 02:16 PM
bhenlee Re: Cell Restrictions allow... 04-22-2015, 02:13 PM
karimel_romeo Re: Cell Restrictions allow... 04-22-2015, 02:21 PM
Tony Valko Re: Cell Restrictions allow... 04-22-2015, 04:53 PM
  1. #1
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Question Cell Restrictions allow only numbers, no special characters

    Hi Guys,

    Can someone please look at the attached and create a validation that will allow the following:

    - only numbers
    - only numbers 0 to 9
    - no special characters of any kind (,":#$%^&* etc)
    - no more than 9 numbers - if so error message
    - no less than 9 numbers - if so error message
    - must be able to start with a 0

    Thank you

    KR
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average calculation of numbers with special characters
    By Ash248 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-06-2013, 06:47 PM
  2. [SOLVED] Calculating the average for numbers with special characters.
    By Ash248 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2013, 01:10 PM
  3. [SOLVED] i want re alter my numbers with special characters
    By vengatvj in forum Excel General
    Replies: 20
    Last Post: 09-30-2013, 06:51 PM
  4. How to calculate only values with numbers not special characters like!
    By toplisek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2013, 06:43 AM
  5. [SOLVED] remove spaces (special characters) after numbers
    By fareastwarriors in forum Excel General
    Replies: 13
    Last Post: 11-04-2012, 09:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1