First of all, thanks for the add-in. I have a problem though and need your help please.
I have an invoice file with separate tabs or Sheets. The main sheet imports data such as price of an item from another workbook via importrange function. Back in my invoice workbook, I simply enter the stock code and quantity and it fetches the results and pastes into the invoice template sheet.
In this template sheet, moneytext function does not work. After a small notice of "Loading", it simply vanishes.
I tested in another fresh sheet and typed some numbers and summed them up. The function worked. I also tried with a small table and pulled the data via Index function, it worked again.
However, whatever I tried in the invoice template sheet or tab, it does not work. In this sheet, if I type the prices, it works. But then, it doesn't make sense to build such a structure and paste necessary data into the template.
Basically, what I notice is the target cell or the cells it is linked to should be formatted as number. I also tried it from the format menu or running the to_pure_number formula, but it doesn't work either.
What kind of workaround would you recommend me ? Thanks in advance for your help.