In the link bellow I shared with u my attempt do automate an google sheets update based on excel (basic copy&paste from one another)
I made it work now… kinda of. The data is being sent to google sheets but for some god damm reason I cant make it as a Number, only Text (in the image I am taking the Text value, but trust me I tried with value before too, and I think parseNumber should make it work any ways)
What can I do to fix it?
-English is not my mother language so sorry for any major mistakes and feel free to correct me
The automation won’t set the type of cell usually, but you can set it in Sheets directly, then any values that get put into those cells will use that format.
Hi @Lucas5, 1) you don’t need to parse date to format it. 2) you don’t need to use replace(), instead put a decimal separator character in a second parameter in parseNumber() method (see photo).
ok, but I use “.” or “,” as separator? Cause make use . as decimal separator but sheets and excel uses , (at least in the worsheets Im using)
also, a small detail: the collum A (date) is allright, just from B and foward that Im having problem (I think this dont change much but I want to clarify it)
@Lucas5, Can you show the example data ? Also if you get data from a source Sheet and it’s already a number type in Sheet (verify with =isnumber() formula in Sheet), you most likely don’t need a parseNumber function. You can just get Range and map directly the value. When pasting in another Sheet, same - just paste as it is. Decimal or point does not matter here, it’s just Sheet formatting issue (visual) as @XenoMax suggested.
Here is an example of the data, is nothing complex.
But also, I find the problem. I set the “insert data option” as “raw” not “user entered”. Now its working. Thanks for the help and your time anyways xD
