I need to set the number format of a certain cellrange to “0.00” so I set style.Numberformat=2. However, I was still able to enter letters…I think that should not be. There should be an option where only entries of numbers are allowed. There should be further options to control the number of decimals…how to enter a number like 1.001 or 3.0327182 ? Again, number format “General” would not work as only numbers should be allowed to enter.
I think number format should work like in Excel, but it seems it does not. Is there a trick?