Results 1 to 6 of 6

Thread: [RESOLVED] Cells must only contain numbers

  1. Jul 26th, 2005, 04:42 AM #1
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Resolved [RESOLVED] Cells must only contain numbers

    Hi once again

    Can I format or use VBA to make cells only contain numbers and letters = nothing ?
    Reply With Quote Reply With Quote
  2. Jul 26th, 2005, 06:52 AM #2
    JustinLabenne
    JustinLabenne is offline
    Lively Member JustinLabenne's Avatar
    Join Date
    Jul 2005
    Location
    Ohio
    Posts
    64

    Re: Cells must only contain numbers

    Have you tried using validation?:

    MenuBar > Data > Validation >
    Justin Labenne
    www.jlxl.net
    Reply With Quote Reply With Quote
  3. Jul 26th, 2005, 06:57 AM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Cells must only contain numbers

    Do you want to allow only numbers to be entered or to eliminate all non-numeric data?
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  4. Jul 27th, 2005, 02:05 PM #4
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Arrow Re: Cells must only contain numbers

    I want to eliminate all non-numerous data I extract from other cells
    Reply With Quote Reply With Quote
  6. Jul 27th, 2005, 05:55 PM #5
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Cells must only contain numbers

    If Not IsNumeric() Then
    ....
    or
    If IsNumeric()
    Details depend on your code.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  7. Aug 1st, 2005, 03:50 AM #6
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Resolved Re: Cells must only contain numbers

    It works with validation only...thanx!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width