K
K
kassi23082021-10-18 19:57:09
Google Apps Script
kassi2308, 2021-10-18 19:57:09

How to make a macro fire as a checkbox in Google Sheets and include a comma to dot replacement in the macro?

Please tell me how to implement:
There is a sequence of numbers in column A. You need to use a macro in column B to insert the same values, but with a dot replaced by a comma (for example, from 3.15 to 3.15). As I understand it, it is necessary to add this condition to the macro code.
I would also like to run a macro using an activated checkbox, for example, in cell C2. If the value in this cell is TRUE, then the macro described above is automatically run.

Is there any chance at all to do this?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-10-18
@ProgrammerForever

=ЕСЛИ(C2;arrayformula(REGEXREPLACE(A:A&"";"\,";"."));"")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question