Results 1 to 2 of 2

No Negative Numbers in a Cell

This is a discussion on No Negative Numbers in a Cell within the Excel Questions forums, part of the Question Forums category; How do I stop a cell from accepting a negative number and display an error message? Thanks for any input....

  1. #1
    Board Regular
    Join Date
    Feb 2004
    Location
    New Jersey
    Posts
    84

    Default No Negative Numbers in a Cell

    How do I stop a cell from accepting a negative number and display an error message?

    Thanks for any input.

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    26,830

    Default Re: No Negative Numbers in a Cell

    Welcome to the Board!

    Goto Data-->Validation-->Settings-->Allow--Whole Number-->Data-->Greater Than-->Minimum-->0. Then Enter your message on the Error Alert tab.

    Hope that helps,

    Smitty

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com