Invertir numeros positivos y negativos

[JessicaM]

Hola!

Tengo una columna con valores positivos y negativos que he cargado desde un fichero excel. Necesito que los numeros que son negativos pase a positivos y que los positivos se conviertan en negativos. Por ejemplo;

Si tengo -150, quiero obtener 150

Y en la misma columna, si tengo 250, quiero obtener -250

Todos los numeros aparecen en una sola columna.

Alguien tiene idea de como hacerlo? He probado con valores absolutos, pero esto mantiene los positivos y no los modifica a negativos. 

Gracias!

[harshnathani · Accepted solution]

Hi @JessicaM ,

Just create a new column which multiplies the column with -1

Column = Table2[Number] * -1

Regards,

Harsh Nathani

[amitchandak]

@JessicaM , That seems strange. Have you used some kind of formatting in excel. Which is showing data that way

Or open power query and check for any steps that is doing this

[JessicaM]

Hi @amitchandak,

Yes, this information is coming from an excel file. But they are extracted from a database with this format. Do you know how to make the change? I found nothing in Power Query so far 😞 

Thanks!

[harshnathani · Accepted solution]

Hi @JessicaM ,

Just create a new column which multiplies the column with -1

Column = Table2[Number] * -1

Regards,

Harsh Nathani

[JessicaM · Accepted solution]

Thanks! I was looking for a formula to calculate the values, but this is perfectly working. Thanks!

[amitchandak]

@JessicaM , Would it possible for you to share a sample so that I can try?