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
2
votes
1
answer
35
views
How to show more decimal places in histogram axis
I have precision long number array in Octave and I would like to show it in histogram. It basically works well but it only shows a few decimal places on the histogram axis. I need to see more numbers ...
- 21
0
votes
0
answers
45
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 ...
0
votes
1
answer
65
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
108
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,069
0
votes
0
answers
35
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
84
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
53
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
36
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
108
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 ...
1
vote
1
answer
110
views
How to handle decimal input values in a globalized MVC app
Currently trying to rework a .NET 4.8 MVC application to support globalization (needs to support both English and French). So far, everything has been working fine.
The issue, however, is with decimal ...
- 1,125
0
votes
1
answer
44
views
React Native TextInput Format Number Amount Comma Separated Number with Decimal Points with two state values
React Native TextInput write Comma Separated Number with Decimal Points with to state values i.e one for presentation and another for pure number value dynamically updated
i.e
SIMILAR TO THE LOGIC OF ...
0
votes
1
answer
48
views
Concatenate two digit year with number formatted with leading zeros
I am trying to create an invoice number with VBA in excel. I want the invoice number to be displayed "YY####" where the number is formatted with leading zeros and will increase by one with ...
- 7
0
votes
1
answer
368
views
Format value for string typed large number in OpenAPI Specification
To represent large numbers in a JSON Schema with high precision, it is a common practice to represent them as a string type to avoid precision loss.
I am wondering if there is a typical format value ...
- 3,386
-6
votes
2
answers
127
views
how to number value in convert in indian currency format. like (120000 to 1.2Lakh & 50000000 to 5Cr [closed]
Hello guys I want to convert my number value in short form but in indian value short form
like
6500 to 6.5K
50000 to 50K
99900 to 99.9K
100000 to 1Lakh
150000 to 1.5Lakh
1000000 to 10Lakh
1450000 to ...
- 31
2
votes
2
answers
89
views
NumberFormat.parse("3.14") returning 314 when used with German Locale
When I try to read the string "3.14" as a float using German Locale I expect one of two things to happen:
(1) throw an error, because that is not a valid way to write 3.14 in German
(2) ...
- 1,436
0
votes
1
answer
29
views
Gravity Forms Dropdown List Display
I created a dropdown list of time - 1 min to 60 mins. When it displays, it is not in sequential order but places all the "1's" together (ie: 1,12,19), then the twos, and so forth. I need it ...
0
votes
1
answer
48
views
Problem with OpenXML Library in C#: Numbers Not Recognized in Excel File Creation
I'm trying to create an Excel file using C# and I'm using the OpenXML library for this purpose. However, I've encountered a problem where numbers are not being recognized in the number format, ...
0
votes
1
answer
363
views
Conversion from MIFARE 14 byte UID to unknown 5 byte number
I have this Mifare 14 byte UID: "04502E22D45380" than i need to have converted to a 5 byte hex: "63AE03D0AA".
I have tried all kinds of conversions on the web and suggestions and ...
- 63
1
vote
1
answer
36
views
How to display correct values for Min, Max, Sum, and Average of negative integers
I'm having trouble trying to display the correct values for Min, Max, Sum, and Average of user-inputted negative integers. When I run my code and enter two negative values (-10 and -30), here are the ...
- 11
-1
votes
3
answers
270
views
How to display numeric value 0.0 as 0.00 as the query result
The value saved in the database is 0.0 as numeric data type.How to display the numeric value 0.0 as 0.00 as the query result?
- 107
0
votes
1
answer
41
views
dart numberformat how to set round or floor with some other case
codes bellow:
import 'package:intl/intl.dart';
void example1() {
final numberFormat = NumberFormat.currency(locale: 'en_US', symbol: '');
numberFormat.minimumFractionDigits = 2; // Minimum number ...
- 25
0
votes
0
answers
45
views
locale attribute in convertNumber tag in XHTML not working in Tomcat
I am using primefaces in my application for UI and in one of the table I have a column for currency in dollar.
Below is the column tag in xhtml, the expected behavior is that whenever the value is ...
- 29
0
votes
2
answers
115
views
What's the solution and the right way to convert digits in JavaScript?
following all qa about converting digits in javascript in Stackoverflow. However, I had a problem/ question
method one
// Convert Persian and Arabic digits to English using the new function
...
- 71
0
votes
1
answer
229
views
Number formatting based on cell value using vba function
I need to create a VBA as a Function, not a Sub, in Excel to format a range of cells based on the cells value. I call the function elsewhere in macro.
If the cell value is greater than or equal to ...
- 3