Re: Spreadsheet - Setting Decimal Point
I found this in my drafts but don't know what it was about.Are you Edwin Irving or Alex Edwin? I know an Alex, but cannot place an Edwin. If you could send me some feedback, would be nice.Thanks; Herb Eichner of heichn...@gmail.com and text to 780 700 6242Home phone 780 433 5521Sent from my Samsung Galaxy smartphone. Original message From: Edwin Irving Date: 2016-10-16 5:46 PM (GMT-07:00) To: users@openoffice.apache.org Subject: 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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Spreadsheet - Setting Decimal Point
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
Re: Spreadsheet - Setting Decimal Point
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’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. 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’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. 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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org