You say could be like that...will it always be?
I guess I build a formula. I would check the totext to see if it has a decimal in it, if so, leave it alone, if not, divide by 100. this should work for preformatted values and non formatted, but if 4250 comes in and that is the value you want OR it can come in as 4250 and you want 42.50 or 425, you are going to need an identifier of some sort to know how much to divide by.
Hope this helped
IP Logged
