I need MACRO to change the value of a cell in excel.
An account type field has the following value: $ 15.326685459.
I need to change the cell automatically so that it stays: R $ 15.32 billion.
Does anyone know how I can do this?
Change cell values excel
0
asked by anonymous 14.06.2018 / 15:02
1 answer
1
You can use this formula instead of a macro:
inglês
=TEXT(ROUND(A1,2),"0.00000000000")
Portuguese
=TEXTO(ARRED(A1,2),"0.00000000000")
14.06.2018 / 17:21