Validation for Numeric values

[Duncs]

I want to add validation to a cell as follows:

Cell is formatted as Accounting, 2 decimal places
Cell can have either whole nunmbers, or decimal entered into it
However, some staff are also entering text
So, what I want to do is, add validation to the cell that will accept
a numeric value, with or without decimals, and prohibit the entry of
anything else.

Can it be done?

TIA

Duncs

 

[Bernard Liengme]

Select the cell; Use Data | Data Validation; specify Allow Decimal
Optionally, open the other two tabs on the Data Validation dialog to add
messages for the fools who type text. Typing text will now cause the PC to
emit a 'bong' - at least that is how mine is set!

best wishes from New Scotland (Nova Scotia, Canada, ye ken)

 

[Bob I]

Select Decimal

 

[Duncs]

Thanks to you both. I'm sure I selected that before, and it wouldn't
let me enter whole numbers.

I must have imagined that though!

Duncs