TEXT function to have the option to convert the displayed format

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

 

2 Comments
Community Manager
 
Status changed to: Considered for Future Roadmap
New Contributor

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.

Users Online
Currently online: 195 members 501 guests
Please welcome our newest community members: