Im not sure whats happening, i am unable to get the error that you are having. When i try it does recognise the decimal.

Maybe if you uploaded a sample workbook we could have a closer look and hopefully find a solution.