I want to display negative values in comma separated format.(-20,000 for negative 20 thousands)
If I am using cell type “ron”, it gives me an “NaN”.
If using “ro”, i cannot apply the number format.
Any suggestions, to resolve this?
must work for any types of incoming value, including negative numbers.
Working sample sent by email.