You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Edwin Irving <ee...@gmail.com> on 2016/10/16 23:46:38 UTC
Spreadsheet - Setting Decimal Point
I want to have columns I set as currency to assume the last two digits should be behind a decimal point. For example, if I input 1257, I automatically want a decimal inserted between the the 2 and 5 to read $12.57. Presently, I have to insert a decimal point with each entry. If I don’t insert a decimal, it is assumed a decimal is to be inserted at the end of the number input and then it inserts a decimal and two zeroes. So if I input 1257, it shows $1257.00 whereas I want $12.57. If I input 12, the application assumes $12.00 and not $0.12
This causes me to insert a decimal point exactly where I want it instead of the application assuming the last two digits are to have a decimal inserted before the two digits.
Also, I don’t think the leading zeroes function is working for at least Format>Cells>Currency. No what number I input for leading zeroes, there isn’t any change in the output number.
I obviously need help.
Thanks you for a great product and your time to create and maintain.
Ed
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Spreadsheet - Setting Decimal Point
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 17/10/16 10:46 AM, Edwin Irving wrote:
> I want to have columns I set as currency to assume the last two digits should be behind a decimal point.
Spreadsheets don't assume things, it expect to get clear instructions
and you are the instructor.
> For example, if I input 1257, I automatically want a decimal inserted between the the 2 and 5 to read $12.57. Presently, I have to insert a decimal point with each entry. If I don’t insert a decimal, it is assumed a decimal is to be inserted at the end of the number input and then it inserts a decimal and two zeroes. So if I input 1257, it shows $1257.00
It shows exactly as is should display currencies with two decimals,
nevertheless you could change the number of
decimals with Cell Formatting.
> whereas I want $12.57. If I input 12, the application assumes $12.00 and not $0.12
> This causes me to insert a decimal point exactly where I want it instead of the application assuming the last two digits are to have a decimal inserted before the two digits.
Learn to live with restrictions of applications, they never do what you
want.
Based on the number of entries you have there are two options:
1. for entering a few numbers just enter the decimal point
2. for a huge number of numbers enter the whole number e.g. 1257 in one
column and enter a formula in the
next column to divide the previous column with 100
>
> Also, I don’t think the leading zeroes function is working for at least Format>Cells>Currency. No what number I input for leading zeroes, there isn’t any change in the output number.
Can you show us what the format code look likes?
>
> I obviously need help.
>
> Thanks you for a great product and your time to create and maintain.
>
> Ed
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Spreadsheet - Setting Decimal Point
Posted by Gary Aitken <op...@dreamchaser.org>.
On 10/16/16 17:46, Edwin Irving wrote:
> I want to have columns I set as currency to assume the last two
> digits should be behind a decimal point. For example, if I input
> 1257, I automatically want a decimal inserted between the the 2 and 5
> to read $12.57. Presently, I have to insert a decimal point with each
> entry. If I don\u2019t insert a decimal, it is assumed a decimal is to be
> inserted at the end of the number input and then it inserts a decimal
> and two zeroes. So if I input 1257, it shows $1257.00 whereas I want
> $12.57. If I input 12, the application assumes $12.00 and not $0.12
> This causes me to insert a decimal point exactly where I want it
> instead of the application assuming the last two digits are to have a
> decimal inserted before the two digits.
I think in order to do that you will need to write a macro to take the
input value and divide it by 100.
> Also, I don\u2019t think the leading zeroes function is working for at
> least Format>Cells>Currency. No what number I input for leading
> zeroes, there isn\u2019t any change in the output number.
The number of leading zeroes applies when there is less than the number
of digits specified in the whole number for the currency amount. So if
the leading zeros is 2, and you enter .23, it displays as 00.23. If
you enter 1.23, it displays as 01.23. If you enter 1234, it displays
as 12.34.
Gary
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org