Validation in Excel

[susilo_saja]

Hi, I need to validate the format of user input in Excel.

For instance , If I have a cell which should only contains number,
I want the user only be able to input number.

I've tried to right-click the cell, choose "Format Cells", and go t
"Number" tab, and change the category from "General" to "Number" , bu
the I still can input anything in the cell.

Fyi, I'm using Windows 2000 and Excel 2000.

Regards,
Susil

 

[Myrna Larson]

You want to use Data/Validation. Read about it in Help.