Force a . separator

Originally Posted by NBVC

You can use data validation for this possibly.

Go to Data|Validation

Select Decimal from the Allow menu

Select Between from the Data menu

Enter a Min and Max value

You can then click the Input and Error tabs to customize the input prompt and Error alert.

This will force the user to use a "real number" between your Min and Max and can include whole numbers or decimals, but not commas...

Thanks NBVC
This would work fine, but the Hours are being entered into a VBA user form, so I need this to work in my exit code as the data is entered into the spreadsheet, see my answer above. Thankyou very much for the quick response thou. MikeG