Hi all,

There is a range only accept numberic with only three decimal. I use number
tab in "format cells" dialogue to do the formatting, but it can not restrict
the other characters such as alphebatic. I tried to use formula, but only
criteria is maxium and minimum. How could I do the restriction.

Clara
thank you so much for your help

Hi, in my opinion, in addition to setting the format you need to set up
validation. Please choose the menu option Data - Validation from the File
menu-bar and select Decimal under the Allow field and select the appropriate
criteria.

"clara" wrote:

Hi all,

There is a range only accept numberic with only three decimal. I use number
tab in "format cells" dialogue to do the formatting, but it can not restrict
the other characters such as alphebatic. I tried to use formula, but only
criteria is maxium and minimum. How could I do the restriction.

Clara
thank you so much for your help