Assuming that your regional delimiter is semicolons (and not commas), your formula should have worked.
Possible reasons it did not work.

1. The value in K2 is set as text and is not being seen as a number.
2. The K2 you refer to is on a different sheet and you need to reference that sheet.
3. Numerous other possibilities that I can't even think of without seeing an example sheet.

Upload an example sheet (Go Advanced>Manage Attachments)