Custom formatting

tony.tomov · Post by **tony.tomov** » Thu Jan 27, 2011 3:01 am

Hello,

I try to format a numeric value so that it shows at end my national currency.
Trying to use the Currency formatter does not work for me, since my currency symbol is not in the list.
I then go to format it with custom formatter, but without success.
I try to use one of the predefined formatters like $0.00, but this seems not to work.

Please advice how to use it with numbers.
It is funny, but it work with dates (other types not tested)

Another recommendation - the currency formatter is ok, but not all symbols are displayed at end of the number.
Please add a possibility to put the symbol before the number too or advise how to use it with custom one

Kind Regards
Tony

Post by **Vladimir** » Thu Jan 27, 2011 5:30 am

Hello,

We have added this feature. Update will be available in prerelease build on February 1.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Feb 03, 2011 1:30 am

Hello,
I can not make this to work (using the version from 01 Feb)

I want to format the number by example 12.34 to 12.34лв.
or
12.34 to $12.34

How can I do this?
Thank you

Kind Regards
Tony

Post by **Vladimir** » Thu Feb 03, 2011 9:06 am

Hello, Tony

To do this you need to specify the currency format of the text as shown on the picture:

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Feb 03, 2011 9:31 am

Hello Vladimir,

Thank you for the quick response.
This work fine.

What about the second case 12099.34 => $ 12,099.34

Actually does the custom formatter "Custom" work with numbers and if yes how?

Thank you
Tony

Post by **Vladimir** » Fri Feb 04, 2011 1:59 am

Hello, Tony

What about the second case 12099.34 => $ 12,099.34

You can set this format, changing the other parameters. Please see attached images.

Actually does the custom formatter "Custom" work with numbers and if yes how?

Unfortunately, Custom Format is currently not fully implemented and works only with the date and time.

Thank you.

thiagorente · Post by **thiagorente** » Wed Mar 02, 2011 12:56 pm

And to format labels on Charts?
There's a way to change the Currency Format of the System?

Post by **Vladimir** » Thu Mar 03, 2011 5:51 am

Hello,

thiagorente wrote:And to format labels on Charts?

In the latest prerelease builds, you can specify any formatting for labels of Charts, for example N2.

thiagorente wrote:There's a way to change the Currency Format of the System?

You can specify any currency formatting, as shown above.

Thank you.