Search code examples
google-sheetslocalizationspreadsheetnumber-formattingsubstitution

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

  • try like this:

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