Ask Your Question

Prohibit non-numerical characters from being entered into a cell [closed]

asked 2019-03-19 20:24:17 +0100

Boggle gravatar image

I'd like to outright prohibit the entry of non-numerical characters into cells (except the . for the decimal).

A conditional format that changes that cell with a non numerical character, to red, would suffice. I tried but was unable to find a conditional format argument that would do this.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-03-25 21:31:55.303832

1 Answer

Sort by » oldest newest most voted

answered 2019-03-20 15:02:37 +0100

erAck gravatar image

updated 2019-03-20 15:03:11 +0100

Conditional formatting changes how cell content and results are displayed, conditional and number formatting is not input masks. To restrict input use Validity, menu Data -> Validity..., in your case Allow Decimal and set Data to not equal some (impossible) value, or some other better fitting condition.

If you only want to display bad input / cell content differently then conditional formatting is fine, assuming you invoked the dialog on cell A1 then as condition use Formula is with NOT(ISNUMBER(A1)) and Apply Style Error, for example.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-03-19 20:24:17 +0100

Seen: 89 times

Last updated: Mar 20 '19