Before we talk about the solution, i do want to talk about 'In Anaplan, just because you can, doesn't mean you should'.
All of us love Anaplan, because it's super flexible and we feel empowered. But we must realize that Text must ONLY be used where ABSOLUTELY NEEDED, and not as a means to capture everything from the source system (at least i think that's why you did what you did). Text takes up a lot of workspace, and it consumed a lot of server overhead in the background, dragging the overall performance of your model.
Please talk to whoever needed, be it the Database folks or the business users to make sure the source is number formatted before sending it over to Anaplan. I might be wrong in my assumption, and please correct me if i'm wrong by providing more context. Do explain the above effects to the client.
Having said that, please see if the following works. Do note that i'm using ROUND, VALUE keyword, and the 'Decimal Point' options in the number format page.