European / UK Currency

Hi Francis

Thank you for your question and welcome to the forum.

I think you could get around this using formatting and conditional formatting.

Firstly I would format the cells to a number with two decimal places.

Secondly try setting data validation on the cells. Go to Data - Validation. Select Decimal, and choose greater than or equal to 0 (assuming all the amounts you are entering into the spreadsheet are positive); then click OK.

Test this out and see if it works for you - if you try entering something into the cells in the european format, the data validation shouldn't allow this to happen.

You can set up error messages and help in the Data Validation when you set up the rule for the validation, to give guidance to people on how to enter figures into the spreadsheet.

Amanda