Changing excel cell values

Asked

Viewed 40 times

0

Need through MACRO to change the value of a cell in excel.

A field of the accounting type has the following value: R$15,326685459.

I need to change the cell automatically to stay: R$15,32000000000.

Does anyone know how I can do it?

excel macro

  • Do you need the numbers 0 at the end? Or it can be rounded and would be R$15,33? Behold this answer with the function arred or round

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")

Browser other questions tagged excel macro

You are not signed in. Login or sign up in order to post.