Hey guys. What's up? I have these two formulas in my excel that are being used to "prepare the data from a web query. Basically what I want to do is strip a number such as x.xxxxx to only x.xx and change to dot to a comma so that the end result it will be x,xx.
So far i have two formulas: =MID(A1,10,4) and =SUBSTITUTE(A5,CHAR(46),CHAR(44)) and I want merge these (or find a better solution).
Thanks.
Bookmarks