Number formatting

Vista, 7, 8, 8.1. Unicode builds: x86, x64, ia64 versions available.

Moderator: Renato

Post Reply
r1ck
New MMEX User
Posts: 2
Joined: Sun Oct 02, 2016 4:20 pm
Are you a spam bot?: No

Number formatting

Post by r1ck »

I know there must be a simple answer to this but I can't find it. How do I format numbers to show as currency ($100.00) vs standard (100)?

thanks
mikhailo2608il
Super MMEX User
Posts: 35
Joined: Tue Jun 12, 2018 3:36 am
Are you a spam bot?: No

Re: Number formatting

Post by mikhailo2608il »

In order to format numbers to appear as currency in MMEX is not especially simple. You have to edit the Template associated with the report and change the HTML tags associated with the field you want to display (a Template variable TMPL_VAR) to be currency. This requires a knowledge of HTML and CSS. And the changes are made to each field manually. I do not consider it to be a simple process. But then I am a rather casual user of HTML and CSS. Certainly it is not as simple as setting an option within MMEX to display your numeric totals as currency - but I do not believe such an option currently exists.

If I needed the numbers from a report that I created in MMEX to be displayed as currency then I would export the report to HTML and import it into a spreadsheet program like Excel and format the numbers as currency within the spreadsheet.

I only hope that someone else can give you a better option.

Regards
Nikolay
MMEX Developer
Posts: 1403
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Number formatting

Post by Nikolay »

1) check USD settings
usd.PNG
usd.PNG (33.13 KiB) Viewed 991 times
siowena
MVP MMEX User
Posts: 116
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Number formatting

Post by siowena »

If you mean in the app, then Nikolay has highlighted the manage currencies dialog to use.

if you mean in reports, I can point you to the report already existing that does that and formats numbers based on SQL outputs.
r1ck
New MMEX User
Posts: 2
Joined: Sun Oct 02, 2016 4:20 pm
Are you a spam bot?: No

Re: Number formatting

Post by r1ck »

Nikolay wrote: Tue Jul 21, 2020 7:54 am 1) check USD settings
usd.PNG
Perfect! Thanks
Post Reply