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-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
