'Converting Google sheet Cell text value to a floating point value

I am using Google spreadsheet from google docs online. I have a text like 1.12345 in Cell C7, and I want to convert it into floating point value for using in below formula. The rest of the cells already contain whole numbers

C5 * C6 / C8 * value(C7)

Here, I am probably using the wrong function as value is not working, I am getting error saying that - VALUE parameter '1.12345' cannot be parsed to a number.

Which function should be used here for converting C7 cell value to a floating point value. Thanks,

Solution 1:^[1]

try like this:

=C5 * C6 / C8 * SUBSTITUTE(C7; "."; ",")

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	player0

'Converting Google sheet Cell text value to a floating point value

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]