TEXT function to have the option to convert the displayed format

Description of the enhancement:

Currently using the TEXT function it will convert the underlying number. For example, if you have:

Line Item 1: Number format, set it to 5 decimals - value: 0.0000005
Line Item 2: Text format, Formula: TEXT(Line Item 1)

Result: 5-E07

Desired Result (in TEXT FORMAT): 0.0000005

Comments

Status changed to: In Review

Thank you for this enhancement.

It would be great if this fucntion could be similar with Excel TEXT function having opportunity to choose final data format.

Like:

TEXT(1234.567,"$#,##0.00") => result $1,234.57

TEXT(TODAY(),"MM/DD/YY") => result 03/14/12

and so on.

Virtual Data Warehouse using Anaplan metadata
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
How CloudWorks Changed My Day-to-Day Work
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
Select All Members in a Time Level Instead of One at a Time
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…