Re: Is there any way i can convert number to text format but still following the number format for c
I would challenge that requirement! You should try to avoid using text and converting numbers to text seems unnecessary.
Have a look at my recent article, Memory Usage From Text Concatenation the same info applies here. Text manipulation creates a lot of memory overhead and uses (and throws away a lot of) memory in the calculation.
This can lead to problems at large scale model sizes.
However, there are several hoops to jump through to return the correct text string.
I would echo @rob_marshall comment here and question why you need to do this.
Here is my approach.
I have split this out across multiple line items as there are several IF THEN ELSE statements that need to come together. The main issue I faced is ensuring that the reference used to pull in the thousands shifted depending on the length of the number.
This example also only goes up to the millions.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA