Answer the question
In order to leave comments, you need to log in
How to replace a combination of numbers and letters in google spreadsheets using a formula?
Good afternoon.
Given:
There is such a combination in the google spreadsheets table: 44.34 rubles.
Required:
To look like this: 44,34
Read https://support.google.com/docs/answer/3098245
But didn't understand what it means:
This function is not suitable for working with numbers, because its input and output have text format. If the output must be a number, use this function in conjunction with VALUE. Input data in the form of numbers must first be converted using the TEXT function.
Thanks in advance for your reply!
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question