Hi,

From the range you had specified, why not use a Data-Validation and
choose

'Whole number' between '40,000 and 104999'.

Choose 'decimal' if you are going to have decimals as well.

Govind.

gocats wrote:
How can set data validation for a cell to accept data between 100 000 and 104
999 or between 40 000 and 99 999?