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?
'₴' 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?
How to prevent Windows 10 from automatically adding keyboard layouts (i.e. US keyboard) Update: this is a lengthy post, you can     Note: The quick language list refers to the list in the screenshot below, accessible throught the shortcut Win + Space bar  I have two languages for windows spell check in my system, English (United States) and French (Switzerland), but despite both languages being properly configured with "Swiss French" input keyboard, US Keyboard input keeps appearing on this list:    Here's the settings for English (United States) language, you can see the only input is "Swiss French":    Same for Français (Suisse), the only input is "Swiss French":    In the Control Panel, both are also set as Swiss French:    All my settings are set to use "language list":     Here's a few things that I already tried:   I already managed to remove it by some language configuration gymnastics, by adding and removing languages, it always eventually comes back I have already done this:  There's no mention of US Keyboard in my registry settings either:     Please help, I'm desperate, this is my third computer with Windows 10 and they all do the same thing. exponentiation of cardinal number Ubuntu 17.10 and later: can't change the input switching shortcut to alt+shift Using my idle computer for something useful (seti@home and the like) Find all positive integers $n$ such that $n$ is divisible by all the positive integers less than or equal to $\sqrt{n}$ Find all positive integers $n$ such that $n$ is divisible by all the positive integers less than or equal to $\sqrt{n}$  My thought: If n is a positive integer, let d(n) denote the number of positive divisors of n and I will find n such that $d(n) \ge 2\sqrt{n} - 1$ A book in which every species on earth was rendered intelligent The 'blurb' on the back of the book was that something had boosted the intelligence of every creature on earth, to the point that at least some animals were on par with humans. I'm not sure if humans were similarly enhanced or just animals. I'm not sure whether it was done by aliens, or a side effect of something humans did, or what.   This book was on the shelves in the mid/late 1980's, so it's nothing more recent than that. I have Windows 8 (final, MSDN) on my Macbook Pro Retina.  Windows 8's ongoing, continuous tantrum of insisting that it's on a tablet device is causing it to always have a touch keyboard 'icon' on  the taskbar.  The 'icon' is actually a toolbar and I can temporarily disable it by right clicking the taskbar and DE-selecting it. However, upon rebooting the system, it always insists on coming back and activating itself.    How can I permanently disable the touch keyboard toolbar in the taskbar? I'm starting out in Visual C++ and I'd like to know how to keep the console window.  For instance this would be a typical "hello world" application:   int _tmain(int argc, _TCHAR* argv[]) {     cout &lt;&lt; "Hello World";     return 0; }   What's the line I'm missing? First post review queue: answers are questions, questions are answers I believe there is a typo in the  review queue. When reviewing a question, the information message asks the user to review the answer. Take a look at the image below.    Similarly, when an answer is posted in the queue, the description box calls it a question instead. Has anyone else noticed this? How to delete a non-empty directory in Terminal? Please don't refer to 2019 as 'a great year' I have    iPhone 5 (with iOS 8.3) MacBook Pro Early 2013 (with OS X Yosemite 10.10.3) iPad Air (with iOS 8.3)   My iPhone is paired with the MacBook, so e.g when my phone rings, I can see it in my computer. But when I want to AirDrop photos from my iPhone the MacBook, then I can't see the MacBook in my iPhone AirDrop targets.  I can see the iPad, I can see my wife's iPhone, but not the MacBook.  On MacBook, I can see the iPad, my wife's phone and even my iPhone and I can drop to there, but not the other way around.  Before I started troubleshooting, the iPhone and MacBook were mutually invisible (I only saw iPad from both). After a while of trying things and sending files back and forth, my MacBook started to see the iPhone, but I did not manage to make it work from the other way. Still, the iPhone seems to be much "less" visible than the iPad - which I see almost instantly and always, the iPhone only seems to appear after a while.  Just to make it clear:   both iPhone and MBP have BT turned on both have AirDrop visibility set to Everyone   I would be glad for any suggestions to fix this - what settings to check, logs, whatever. How do I effectively defeat the Wall of Flesh? I've been having trouble defeating this monster. Even with lots of buff potions, health potions, high tier armor (Molten), and ranged weapons with plenty of ammo (Minishark), I can't seem to kill this boss.  Worse, when I get it down to about 2000 hp, even if I'm fairly far away, it'll suck me in and continually rise towards the skybox, which doesn't allow me to do anything for some reason.  How do I defeat the Wall of Flesh? What gear should I be using and what kind of potions do I need? Every time Windows 10 runs updates (which I see no way to control), it updates my graphics driver.  I like the old one because it is faster.  So, I have to reinstall it.  This is getting to be a pain.  Is there any way to stop Windows 10 from updating it again? We are asked the following:      let $f(x)$ be a continuous function on $[0, 1]$ such that   $$\int _ {0} ^ {1} \ f(y) dy = 1$$   prove that $f(x) = 1$ for some $x ∈ [0, 1]$   The question asks to take into account Rolle's Theorem and Mean Value Theorem.  I'm aware of the definitions, but I am really unsure how to answer this question and my tutors are not really responding till after easter.    Could someone please help? Why is there a "y" involved?  Thanks you Since the final Black Hole (BH) had 3 solar masses less of mass than the original binary BH, it seems the 2 BHs lost mass, and with it event surface area, entropy, and information. If that came from inside the BHs it seems that it would be a contradiction of what a BH is --'nothing escapes its event horizon'. Some may say that came from the rotational energy of the pair, but the new BH now seems to have less than the two original ones summed. So, did some of that escape the horizons? SELECT GETDATE()   Returns: 2008-09-22 15:24:13.790  I want that date part without the time part: 2008-09-22 00:00:00.000  How can I get that? Since it seems to me, that a lot of people still need sidebar workarounds, I would be interested to learn about the use-cases, experienced challenges and (most important) possible strategies to avoid them by using different approaches. This is related to the methods discussed here:   In my experience there are a few extremely important and constantly repeating patterns, which to my knowledge are still very hard to be solved using more official techniques. I will also contribute my own top-N use-cases, which are mostly related to UX and UI concerns. You are very welcome to add your own scenarios as answers and add comments on how you would avoid a workaround. My dream would be to team-elaborate strong and repeatable solution-patterns for the most common use-cases.  Finally I would be interested in the experiences of all of you who participate in the Aura pilot, which hopefully could make this kind of workarounds obsolete. Remote start up a machine that is in the shut down state? Possible Duplicate:          May I know how can one remote start up a machine that is in a shut down state? Why only 1 public class in Java file