Questions tagged [currency]

Currency is a medium of exchange of value, usually referring to government issued denominations.

The Currency tag is relevant to any topic that involves the handling of currency, including accurate calculation, rounding schemes, best practices and display formatting. It is also applicable to discussions of how specific languages or libraries handle currency.

http://en.wikipedia.org/wiki/Currency

2964 questions
1
vote
0 answers

Following a Number Format but keeping a different symbol

I'm trying to create a Winform that allows a user to select a currency symbol AND a currency format (by inputting the locale for it). I would like to have a number follow that selected format but yet ignore the default Currency Symbol belonging to…
Paul Williams
  • 1,554
  • 7
  • 40
  • 75
1
vote
2 answers

tsql - update money field to round to nearest hundredth (2 decimal places)

What would be a query to update a money field to the hundredth. I've got some values that go out to the thousandth because I didn't round them going into the database. Now I need to fix that. I was thinking along the lines of: UPDATE…
Redtopia
  • 4,947
  • 7
  • 45
  • 68
1
vote
2 answers

Monetary symbol (not $) in DataGridView field values

I'm building an application that is for a non-profit in Guatemala. Everything in the system is in Quetzales, which is denoted with a Q (i.e. Q100.00) is 100 Quetzales. I need to be able to modify the monetary values in any DataGridView column, but…
Ricky
  • 1,587
  • 2
  • 12
  • 20
1
vote
2 answers

Jquery AutoNumeric does not work when form is a LIVE form

I made an input-control of an input field with "auto numeric". AutoNumeric Website It works well in normal mode, but when I load the content (with form) live through ajax it does not work. Do somebody have an idea? jQuery(function($) { …
DragonStyle
  • 145
  • 11
1
vote
1 answer

How to covert currency as per locale ID

I am using locale Id(LCID) in classic ASP. I have currency in 7177 locale Id(South Africa). I want to convert it to the currency with locale id 3081(Australia). For example, if input is 13,10 then output should be 13.10. I try this : function…
SandipIntrop
  • 25
  • 1
  • 4
1
vote
3 answers

Python Regular Expression to match specific currency format

I'm trying to write a regular expression in python 3.4 that will take the input from a text file of potential prices and match for valid formatting. The requirements are that the price be in $X.YY or $X format where X must be greater than 0. Invalid…
C.B
  • 17
  • 1
  • 4
1
vote
1 answer

Ruby on rails currency switcher for whole site

I've been searching for hours and viewed all google results one by one... Read about RubyMoney, Money-Rails. I'm new to rails and I still can't understand how to get a currency switcher for my whole Ruby on Rails app. In my Gemfile gem…
user6198643
1
vote
1 answer

How to calculate remainder while accounting for hundredths digit for currency operations

I need to divide a USD amount by a number of months for a payment schedule, and I want to be able to get the remainder of the division if the money doesn't divide cleanly. Normally I would just use a modulus operation to get the remainder but I need…
Fam
  • 580
  • 1
  • 7
  • 29
1
vote
2 answers

Properly filtering an input field in Angular

I found this directive for filtering a field for currency, so a user just needs to type and the decimal is implied. It works well, except that a user is able to put in a letter if they press a letter twice. I don't want them to be able to put in a…
jenryb
  • 2,017
  • 12
  • 35
  • 72
1
vote
2 answers

Converting float to currency Argentine Peso

It seems that the Argentine Peso (ARS) notation for currency is complete the opposite from what the Dollar is in the US. The , is used as a decimal separator, and the . is used as a thousands separator. 1121 => $1.121,00 1000.5 => $1.000,50 85.72…
ThomasReggi
  • 55,053
  • 85
  • 237
  • 424
1
vote
2 answers

mortgage calc returning negatives

I'm trying to deal with money (probably the wrong way as far as best practices but I thought it would work.. its simple, multiply everything by 100 and then use ints) import java.util.Scanner; public class PFiveFifteen { public static void…
dosmastr
  • 7
  • 5
1
vote
0 answers

Display Unicode and HTML currency symbols in php

I would like to display a couple of currency codes in php but cannot seem to get it working. PHP script is encoded in utf-8, which is also the charset used in HTML: doctype: meta: Viewed in Firefox with no…
Argoron
  • 749
  • 2
  • 10
  • 26
1
vote
0 answers

automatical mask input currency [pure js]

i was looking around in the forum but i cant find anything like my case, sorry if duplicated. i was found mask currency js but not work when im try to send the value into input text value. the error is result from var masknumber can't fill in result…
SRL
  • 77
  • 11
1
vote
0 answers

Excel : get a cell's value in cell custom format

My problem is simple, but I can't seem to find a solution : In my Excel sheet, I have many money cells, and I just want to change the currency symbol displayed, "dynamically". What I would like to do is set a cell with the currency symbol and get…
brinxx
  • 11
  • 2
1
vote
3 answers

Unidad de Fomento (CLF/UF) and money gem

I've been struggling to understand how does the money gem formats the Unidad de Fomento. I've tested the version 6.5 and the 6.7 and both seems to present odd formats: # Money 6.5 usd = Money.new(243, 'USD') usd.to_f #=> 2.43 usd.format #=>…
John
  • 588
  • 1
  • 6
  • 22