how to Format Cells so they only except numbers

[Rob Nash]

How do i make a cell only except numbers, i.e. you carn't type text in , it will only allow numeric values to be entered.
Cheers
Jason

 

[Aladin Akyurek]

On 2002-11-17 08:30, Rob Nash wrote:
How do i make a cell only except numbers, i.e. you carn't type text in , it will only allow numeric values to be entered.
Cheers
Jason

Let A2:A20 be the range of interest.

(1.) Select A2:A20.
(2.) Activate Data|Validation.
(3.) Choose Custom for Allow.
(4.) Enter the following in the Formula box:

=ISNUMBER(A2)

(5.) Click OK.

Note. The above setup can be defused by Copy & Paste.

 

[Lucien]

Rob,
You can also use Data, Validation and than goto "decimal" in the drop down box "allow". You can extend this with an error allert when text is inputed. You do this by going to the eror alert in the menu.