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

Originally Posted by Leith Ross

Hello MikeGonza,

Welcome ot the Forum!

The answer depends on what type of "form" you are referring to. Is this a worksheet or a VBA UserForm?

Yes thanks Leith
I enter the Hours into a user form so the Data validation answer below would work, but I need to put it into my code when I exit the user form and enter the data into the cell.
any thoughts?