Decimals in Open Office
reno
-
reno -
reno -
Bonjour,
the question is very basic, but I don't care, I'll ask it anyway.
How to set up Open Office 3.01 so that when entering a number in a cell, the comma automatically places itself two digits from the right.
EXAMPLE: I type 12345 without entering the comma and I want it to display and take into account 123.45
it's easy to configure in Excel and it's nowhere to be found in OO3.01 thanks for answering.
the question is very basic, but I don't care, I'll ask it anyway.
How to set up Open Office 3.01 so that when entering a number in a cell, the comma automatically places itself two digits from the right.
EXAMPLE: I type 12345 without entering the comma and I want it to display and take into account 123.45
it's easy to configure in Excel and it's nowhere to be found in OO3.01 thanks for answering.
Configuration: Windows XP Firefox 3.0.7
2 answers
-
Hello,
If your decimal separator is not the comma:
In the "Format / Cells..." menu -> Numbers -> Custom: "#,##"
Be careful, we are only adding a comma (in this case, but it could be another character) in the display of the number and not forcing it to two decimals. Any calculations will therefore be performed on the whole number entered.
To force the number to two decimals, you can for example:
- simply divide by 100
- use find/replace: find ("Other options/regular expression"): "([0-9]{1,2})$" Replace: ",$1"
How do you do it on Excel? -
Thank you to Dubcek because indeed with Excel it's very easy and exactly what you explain, but on Open Office there is no such option (modify), so my question is not as basic as that.
Thank you to Herr Dr von Apfelstrudel (very tasty name) but if the consideration of the comma does not take place, it doesn't have a real interest.
Nevertheless, thank you for the research. I hope to get more answers and I hope that Herr Dr enjoys being bitten!!! (that's humor!)
