formatting

[i4696]

 Hello, i'm appending two tables with two columns: One is projects and the other is actuals.. The issus is that actual come in idfferent formats. In table one is regularnumber let's say: 100.000 € the other is in 100 K €. Is there any way I can homogenize both formats without changing sourcing tables?

Thanks in advance.

[MFelix · Accepted solution]

Hi @i4696,

The best way is to do it in the query editor, maknig the formatting change creating a new column and then deleting the previous one. The query editor is like a macro and every single time you update your data the steps are run and your information is prepared as your need, and you don't need to make the changes on the original data.

Regards,

MFelix