Restrict a Field Value Text only No numeric

Question

no numeric value But compel text charactor only ina field value

Answer 1

You were not very clear.

Do you want to insure the value in the field is text even if it contains digits? That is, reject 3.14 but allow ab123 and allow "345". If so, then the custom data validation formula

=NOT(ISNUMBER(A1))

will reject numerical values including dates and times.

If you want to exclude numeric digits, then the formula is a bit more complex

=NOT(ISNUMBER(SEARCH("0",A2))+ISNUMBER(SEARCH("1",A2)))

will exclude digits 0 and 1. You can easily extend it to the other eight.