My user insert a hash or a sequence of 48 digits.
For example 846900000015259602962021103150630004002081451896
using this formula after saved value(MID(A1103;5;7)&mid(A1103;13;2)&","&mid(A1103;15;2)) get the amount of this bill R$125,96826500000011699901066406457784431910522700000006
in this R$169,99
I´d like to check before save, if the user entry the same value of code or show the amount got in the code the user typed in order to check if the amount is the same of bill.
I was thought using a template and show the text box but I don’t now if I can use these formulas.