# 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
```