Why does Excel use 3 decimal places for currency when I have the cell set to 2 decimal places

Channel:
Peter Schneider
Subscribers:
4,120
Published on ● Video Link: https://www.youtube.com/watch?v=TIfLeZjB2XQ


Duration: 2:03
0 views
0

Why does Excel use 3 decimal places for currency when I have the cell set to 2 decimal places
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/licensing) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(superuser.com/users/433655/andrewh)AndrewH
(superuser.com/users/1247873/mayukh-bhattacharya)Mayukh Bhattacharya
A special thanks goes out to the (superuser.com/questions/1826512/why-does-excel-use-3-decimal-places-for-currency-when-i-have-the-cell-set-to-2-d)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

microsoft-excel



Other Videos By Peter Schneider


2024-07-22Apple: How do you position your hand to use the command key? What finger do you use?
2024-07-22Mathematica: Using Manipulate On Parametric Plots
2024-07-22Mathematica: How to show two plots with different axes?
2024-07-22Apple: Control-F2 "Move Focus to Menu Bar" only works occasionally
2024-07-22Apple: How to switch between multiple fullscreen windows of same application in OS X?
2024-07-22how to modify the text of a button if it meets certain expectations?
2024-07-22Tex: How can I add top (and bottom) padding to a pNiceMatrix?
2024-07-22Gis: ArcGIS Pro Accumulate Distance Vs Euclidean Distance
2024-07-22Unix: I am trying to emulate a board which has a OLED display, but can't see anything. Can you te...
2024-07-22What is happening when R combines two vectors using c()?
2024-07-21Why does Excel use 3 decimal places for currency when I have the cell set to 2 decimal places
2024-07-21Tex: babel+newtx+superiours+stmaryrd+LS1+LS2+biblatex+biber+cite+mathsf+mathit+mathbf+printbiblio...
2024-07-21Apple: How does my Selfie Stick take a picture using the *headphone socket*?
2024-07-21Electronics: Is a 100R/1nF RC enough to protect microcontroller IO pin from ESD?
2024-07-21PowerShell Optimize Performance
2024-07-21Gis: Cannot plot geometry on a CSV file (Python)
2024-07-21Ethereum: How to enter values in a tuple in a contract function?
2024-07-21Tex: Force LuaTeX to ignore unknown Unicode characters
2024-07-21Apple: and keys are swapped
2024-07-21Mathematica: How to plot such beautiful Calabi–Yau manifold?
2024-07-21Tex: Is there no better way to draw this TikZ graph?


Tags:
microsoft-excel