Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Validation Problem (Excel 2002/2003)

    Hi


    Please see attached I have set the Data Validation to Decimal - Min 0.5 and Max to 6, but I can't seem to enter anything between these numbers.

    Any Ideas please

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Validation Problem (Excel 2002/2003)

    Hi,
    Your cell is formatted as a percentage, so you can only enter values between 50% and 600%.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Validation Problem (Excel 2002/2003)

    Hi Rory

    Thanks for the reply is there a way to get what I want?

    Or do i have to change the formatting to general, the thing is the percentage is used as diluting volume.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Validation Problem (Excel 2002/2003)

    It depends what you want. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    If you want to be restricted to values between 0.5% and 6%, then change the minimum and maximum from 0.5 and 6 to 0.005 and 0.06
    If you want something else, can you explain what?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Validation Problem (Excel 2002/2003)

    Hi Rory

    That works fine for me, thanks very much.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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