Format cells to only accept numbers

[cradino]

How can we format and protect cells to not accept text, only numbers?

[SteveG]

cradino,

Use data validation. Select the cells you want to apply the data validation to. Go to Data>Validation. Select Decimal or Whole number from the Allow list then choose your minimum and maximum number and click OK.

HTH

Steve