Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi;
I would like to change number format and font via edit expression mode.
how can i do it?
Thanks in advance...
You can change the number format using something like this:
=Num ( YourNumberValueField , '#,##0.00;(#,##0.00);-' )
The string that you use for the number format is pretty standard so I'm sure you can work out all the options you have there, one warning though, if your end-users do a lot of exporting to excel of this data, using the above formatting means that number formatting in excel will be removed.
I use a variable in place of the '#,##0.00' string, which then allows me to give buttons to the end-users so they can change decimal places etc, those buttons just change the variable.
As for changing the font in the same expression, no, I don't think it's possible. You can create expressions underneath the main expression that allows you to control the format and colour of the text, but not the font itself.
You can change the number format using something like this:
=Num ( YourNumberValueField , '#,##0.00;(#,##0.00);-' )
The string that you use for the number format is pretty standard so I'm sure you can work out all the options you have there, one warning though, if your end-users do a lot of exporting to excel of this data, using the above formatting means that number formatting in excel will be removed.
I use a variable in place of the '#,##0.00' string, which then allows me to give buttons to the end-users so they can change decimal places etc, those buttons just change the variable.
As for changing the font in the same expression, no, I don't think it's possible. You can create expressions underneath the main expression that allows you to control the format and colour of the text, but not the font itself.
Thank you so much for your solution and advices...
It works as full