I want to write currency in the format:  ₽ 3 812.23   But if I select Russia as region in the table settings and format the string  ₽ 0.00   result formatted number like  ₽ 3 812,23   with a comma, because the comma is default separator in Russian locale. How to change comma to dot?
122829
'₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004. I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a number if I add it after or before my value in the cell. How do I make Google Spreadsheets understand it's currency and display it as a number in my desired format?
80706
I have created a custom format ##,##0.0,,, CTRL+J %% in Excel 2010 to display  10000 as 0.1 100000 as 1.0 1000000 as 10.0 10000000 as 100.0 100000000 as 1,000.0 and so forth.  The problem I am facing is that once I apply this format, save and close the workbook, the next time I open it the format gets changed by multiplying by 10 (100000 is displayed as 10.0).  I don't understand how it is getting changed automatically the next time I open it. However, when I apply other formats they remain unchanged.
103563
I read that different cultures have different ways of grouping digits before the decimal point for readability e.g. 1234567890 can be grouped as 1 234 567 890 (English), 12 3456 7890 (Chinese) or 1 23 45 67 890 (Indian), but is there an established convention for grouping digits of a real number after the decimal point for readability e.g. should 3.14159265358979 be grouped as 3.141 592 653 589 79, 3.14159 26535 8979 or something else?
20276
I want to add a comma in the thousands place for a number.     String.Format()?
90637
Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02  How do I stop this from happening?
71533
Can I add the comma "," to force the decimals to remove from the attribute and replace with the number?   For example, I have an Acres field column that says 506320.0750 and I want to replace the decimal with the comma, say 506,320? I want that number to be permanment.   Is that possible? I'm using ArcGIS Desktop 9.3.1
39431
I am trying to plot data from data files which are using the comma as decimal separator instead of a point (as is normal in SI style (French version):  ). However, even after excessive search I cannot find an option that would actually tell pgfplots to read the table with the comma as decimal separator. Minimal (not) working sample:  \documentclass[paper=a4,12pt,version=last,landscape]{scrartcl} \usepackage{tikz} \usepackage{pgfplots} \begin{document} \centering \begin{tikzpicture}     \begin{axis}[             width=0.9\textwidth,             height=0.5\textheight,             xlabel={Standardweg~[mm]},             ylabel={Standardkraft~[N]},             grid=major,             ]         \addplot table[x=Standardweg, y=Standardkraft] {Messwerte.TRA};     \end{axis} \end{tikzpicture} \end{document}   Messwerte.TRA:  Standardweg  Standardkraft 0,000000000000e+000  1,960904836655e+000 -2,349615044750e-004     3,081407308578e+000 -2,349615044750e-004     4,164415359497e+000 -2,349615044750e-004     5,441759109497e+000 -2,349615044750e-004     6,443712234497e+000 -2,349615044750e-004     7,598009109497e+000 -2,349615044750e-004     8,951524734497e+000 -6,029571522959e-001     1,002574348450e+001 -2,349615044750e-004     1,122496223450e+001 -2,349615044750e-004     1,252183723450e+001   On compilation, I get the error: ! Package PGF Math Error: Could not parse input '-2,349615044750e-004' as a floating point number, sorry. The unreadable part was near ',349615044750e-004'.. for every single number in the .TRA-file.  I know that I could find and replace every , with a . in the files, but that is not an option considering the amount of files I have to evaluate.  Also, I tried stuff like /pgf/number format/use comma, set decimal separator={{,}}, \pgfkeys{/pgf/number format/.cd,fixed,precision=2,use period} and use comma, but none of that helped and I am pretty much running out of options. The documentation for pgfplots did not give any other ideas, either.  So: How do I convince pgfplots to actually read the comma as decimal separator and to not search for the point?
42076
If you click the Stack Exchange site drop-down menu:        and look closely at the  menu item for "Русский язык", you'll see the following:      .   At the moment it is read as     "For лингвистов, этимологов, и энтузиастов русского языка"   Just two notes:   It is better to put "Для" instead of "For". According to rules, the comma before "и" is an error.   So, the whole line should be written as:      "Для лингвистов, этимологов и энтузиастов русского языка"
715
I would like to format a price in JavaScript. I'd like a function which takes a float as an argument and returns a string formatted like this: &quot;$ 2,500.00&quot;  What's the best way to do this?
6342
I want to write something basic like "10 $US" but sometimes it makes the text look weird. It changes the font and writes italic text. And sometimes it will insert a newline. For example in my .  How can I safely insert a dollar sign?
63278
In my locale, date is inserted as dd/mm/yyyy or variations of that (including dd-mm-yy). I made an Excel form (in normal Excel file), already formatted to show date as dd/mm/yyyy, but when I typed "05/04/2015" it will be shown as "04/05/2015". I know this can be solved by changing the regional setting to my local setting, but I need to distribute this form to a lot of people with no knowledge of changing regional setting, and assuming no one can teach how to, hence my question :  Is there any way to input "05/04/2015" and be recognized as "5 April 2015", without having to change regional settings ?  Additional note: When I mean "4 May 15" (typed in 4/5/15), Excel will recognize this as "5 April 15" because Excel takes input as "mm/dd/yy" format. I need to change the default behavior of Excel to take as "dd/mm/yyyy" as this is the way the users will input.  If possible, the setting should also included/embedded on the file to allow end-users use the form without even changing setting.  I'm not familiar with macros and VBA, but willing to try those :)  EDIT : this is related to my question :   but I don't need to change the whole formula bar, as long as Excel recognize that I'm typing in dd/mm/yy format.
102090
I'm trying to process some data in Excel. The data includes numeric account numbers and other long numeric strings (like cell phone MEIDs). I am not doing math operations on these strings, so I want Excel to treat them as plain text.  Here is what is making me nuts (this is Excel 2010):   Take a long number like 1240800388917 and paste it in a cell in a new worksheet. Excel's default cell format is general, so the string is presented in scientific notation as 1.2408E+12 Right click on the cell, select Format Cells, set the format to Text   The cell is still displayed in scientific notation, even though the format has been set to text.  Now, if I do the steps in a different order:   Format an empty cell as text. Right click on the cell, select Format Cells, set the format to Text Take a long number like 1240800388917 and paste it in to the text formatted cell   Now, the cell is displayed as a string and not in scientific notation.  The results remaining in scientific notation even though the cell is formatted as text just seems broken to me. I've seen suggested work-arounds like: use CSV import and set the format to text, add a space character to the beginning of each numeric string, and others.  Is there a simple good work around to easily keep these strings formatted as text?  Why on earth does Excel do this?  Related SU questions I found:  and
96922
Why when I save a value of say 40.54 in SQL Server to a column of type Real does it return to me a value that is more like 40.53999878999 instead of 40.54?  I've seen this a few times but have never figured out quite why it happens.  Has anyone else experienced this issue and if so causes it?
82081
In LibreOffice Calc, if I have a column with a lot of numbers in this format 8,1 (comma), how  can I transfer all these numbers to the format 8.1 (dot)?  When I say "a lot" I mean thousands of numbers, so it is just impossible to rewrite it again in the right format.
53059
I would like to format binary or hexadecimal numbers with a space separator at each 2 or 4 digit (or any other value like 8 digit or more).  A small picture is better than a long explanation, here is what I would like to do:    As you can see in this mwe, I use the fmtcount package with padzeroes:      \documentclass{article}     \usepackage[utf8]{inputenc}         \usepackage[T1]{fontenc}               \usepackage{fmtcount}     \begin{document}             Binary value : {\padzeroes[16]\binarynum{129}}$_{(2)}$ %             should display 0000 0000 1000 0001$_{(2)}$              Hexadecimal value: {\padzeroes[8]\Hexadecimalnum{65000}}$_{(16)}$ %             should display  00 00 FD E8$_{(2)}$     \end{document}   What I want to do is displaying numbers with various radix (2, 3, 7, 8, 10, 16) given a decimal number and format these numbers correctly with spaces and leading 0 (without having to perform the conversion by myself).  I already found some posts with similar questions, but none of them achieve this (they display number with thousand separators, like the numprint package, every 3 digits; or they do not make it automatic). Here are these posts :         EDIT two other linked questions:       I also prefer to use pdflatex.
102420
Something like:  0.1 0.23 0.999   How to pronounce them correctly in English?
26726
Note I'm not actually planning on writing any, for instance, Russian prose or even any Russian words. It's just that, on paper, I've always had the habit of denoting sets by uppercase roman letters, sets of sets by script letters and, when the need arises, sets of sets of sets by uppercase Cyrillic letters. Is there some package I can load which will allow me to typeset (in LaTeX math mode) Cyrillic letters much as I would typeset Greek letters? ie. $\Zhe$ to produce an uppercase zhe. Thanks!