Questions tagged [number-formatting]
Number formatting is the process of converting a numeric value into a string suitable for display. Things to take into account are the decimal/thousands separator, digit grouping, the shape of the numbers, how a percentage or currency is displayed, and so on.
number-formatting
2,877
questions
0
votes
0
answers
38
views
How to format the numeric value of a cell in Excel using flutter?
I use the Excel library in Flutter Project, there are formatting template classes(NumFormat), but there is no currency formatting to display the ruble or dollar sign.
The library makes it possible to ...
-1
votes
0
answers
18
views
Including "IF, THEN" statements into a macro that also has NumberFormats
Putting this all together is giving me a migraine. I'm sure this will be easy enough for most of you.
When I download activity from my checking account it arrives with five columns and x number of ...
0
votes
1
answer
54
views
MudBlazor MudNumercField with thousand separator
Can I set Format parameter somehow to display the number with thousand separatot in MudNumericField, please. I tried to set it to "n" but it didn't work.
For example: 151 342
- 683
1
vote
2
answers
106
views
How to make 0.100000000000001 caused by rounding effects become 0.1 again?
When doing "correct mathematics" floating point effects cause a number 0.1 to become 0.100000000000001.
So I want to do some "rounding", but I'm unsure how to do it:
When doing ...
- 4,053
0
votes
0
answers
34
views
Can I Numberformat a date and then change to string to add additional characters to the end?
I have some dates I'm pulling from a database. These dates will go onto a Government report where they want these dates changed to UTC. Then, they want it formatted as "yyyy-mm-ddThh:mm:ss-[UTC ...
0
votes
1
answer
72
views
Tabulator - Specify number of decimal on numeric field
I'm using Tabulator 6.2 and I want to specify the number of decimals on numeric field.
I read the data from a SQL table and show the data on the table but the value shown have a lot of decimal numbers
...
1
vote
1
answer
50
views
How to Automatically Format Numbers as Indian Numeration in HTML Input Fields?
I am working on a financial web application targeted at an Indian audience, and I need to allow users to enter monetary amounts in input fields that automatically format the numbers into Indian ...
0
votes
1
answer
33
views
Excel TEXT function not filling cell when `* ` is present
I am trying to format numbers in Excel, and my desired outcome is similar to the Accounting format, where the $ is on the left and the value is on the right. I'm trying to include multiple numbers, so ...
- 535
0
votes
0
answers
14
views
Number not formatting correctly for locale countries when the range in between 1000 - 9999 in Javascript NumberFormat [duplicate]
I am using the following method - NumberFormat() to format numbers for locale countries. Most of the numbers formatting is correct but for numbers from 1000 - 9999 it is not adding any spaces. Though ...
- 2,453
-1
votes
1
answer
35
views
How to use custom number formatting in excel?
I have a large dataset which has been converted from .csv to .xlsx and I am having trouble with number formatting. I would like to convert values such as 258.325 and/or 1.675.305 to display 25.325 and ...
- 17
1
vote
5
answers
104
views
What would be the most efficient way to encode a simple fraction on 32 or 64 bits? [closed]
What would be the best way to encode a positive simple fraction on 32 bits or 64 bits?
For casual binary fraction, we already have a well defined standard for floats and doubles.
In case of 32 bits, ...
- 119
0
votes
0
answers
16
views
Unable to Set NumberFormat to "DZD" in VBA for Specific Rows [duplicate]
I am encountering an issue with setting the number format to "DZD" for specific rows in VBA. Here's the relevant part of my code:
For rowNumber = 6 To 15
' Set the currency symbol for ...
0
votes
0
answers
43
views
Is there an elegant way to handle VERY large numbers? [duplicate]
I am making a python clicker game, and in my art.py file, I handle all numbers from 0-1k. Once the program reaches +999, the format switches from {hundreds + tens + ones} to {thousands + decimal + ...
1
vote
1
answer
29
views
sqlite3 format "12345.6789" to "12,345.68" on the native command line
This works as expected:
select printf("%f", 12345.6789); 12345.678900
This works as expected:
select printf("%.2f", 12345.6789); 12345.68
This works as expected (notice the comma):
...
- 13
1
vote
3
answers
83
views
How can I convert currency to a number?
I am using javascript and I've seen some ways to convert a currency to a number, but not one that is flexible to understand multiple input formats (decimal separator changes based on the user ...
