I have a google spreadsheet tab that needs to be copied to another sheet. In most columns I can set the formatting to the proper currency formatting, so when copying the column, the format is kept and the data is copied correctly.
In one of the columns I have some of the cells in one currency, and some other cells in another currency, therefore I cannot apply a currency formatting to this column, and this column has an automatic formatting.
When copying this column, the numbers are copied as values without formatting and displayed as plain numbers.
I am copying the values with the CopyValuesToRange method.
Is there a way to copy the text as is - with the currency sign? Or maybe apply a conditional currency formatting for each cell based on the cell's text?