Calc: Formatting cell with decimal point but no decimal digits

users
#1

Hi list,

I'd like to input 123.45 and format it with a decimal point
but no decimal digits, in this example "123." . Previously I
used the formatting code #,##0"." but now it causes an input
of 123.45 to be received as 12,345, losing the decimal.

Any ideas?

Thanks in advance.

#2

In calc, you could format the cell as currency.

#3

In calc, you could format the cell as currency.

Thanks, I tried this, but wasn't able to display a terminal
decimal point.

#4

Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
number format to "#,##0\." (without the quotes, of course) works for me.
("#,##0.." also works, but that's too bizarre. :wink:

Chuck

> In calc, you could format the cell as currency.

Thanks, I tried this, but wasn't able to display a terminal
decimal point.

> > Hi list,
> >
> > I'd like to input 123.45 and format it with a decimal point
> > but no decimal digits, in this example "123." . Previously I
> > used the formatting code #,##0"." but now it causes an input
> > of 123.45 to be received as 12,345, losing the decimal.
> >
> > Any ideas?
> >
> > Thanks in advance.

[snip]

#5

Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
number format to "#,##0\." (without the quotes, of course) works for me.
("#,##0.." also works, but that's too bizarre. :wink:

On my version (6.1.5) both of these formats display the cell
contents with a trailing decimal point, but with this
formatting, inputting 123.45 results in cell content 12345.

#6

This thread caught my eye and I can't imagine the use case for displaying the digital point as the OP wishes - but I gave his model a try as I did also with the two expressions proposed by Chuck. I am using Calc 6.4.7.2 in Ubuntu 20.04.2  The results were surprising.

I entered 123.59 in some cells in 3 columns formatted as: -

1) Numbers #,##0"."

2) Numbers #,##0\.

3) Numbers  #,##0..

All three columns then displayed my entries as "124."   ie, rounded up and with a final "."

But, when I entered 123.59 into other empty cells in those 3 pre-formatted columns, my new entries were displayed as "12,359." in each case.

So applying the format to an already entered number gives a final "." - I don't know whether the rounding up is acceptable or not. But I imagine the OP wants to enter his number into cells that already have his format applied.

Curiously, when I selected my 3 columns and attempted to return to 'normality' by formatting the cells to Numbers > General, nothing happened. I had to change to some other format than Number (eg date) and then back to numbers-general to get a result.

When Numbers-General was eventually restored, the "124."  entries were returned to their original states of "123.59" but those entries applied to the pre-formatted columns and which then displayed as "12,359." became "12359" under the restored numbers-general regime.

Philip

#7

with decimal point but
  no decimal digits
Date sent: Tue, 11 May 2021 13:24:26 +0200

>> Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
>> number format to "#,##0\." (without the quotes, of course) works for me.
>> ("#,##0.." also works, but that's too bizarre.:wink:
>
> On my version (6.1.5) both of these formats display the cell
> contents with a trailing decimal point, but with this
> formatting, inputting 123.45 results in cell content 12345.

This thread caught my eye and I can't imagine the use case for displaying the digital point as the OP wishes - but I gave his model a try as I did also with the two expressions proposed by Chuck. I am using Calc 6.4.7.2 in Ubuntu 20.04.2  The results were surprising.

I entered 123.59 in some cells in 3 columns formatted as: -

1) Numbers #,##0"."

2) Numbers #,##0\.

3) Numbers  #,##0..

All three columns then displayed my entries as "124."   ie, rounded up and with a final "."

But, when I entered 123.59 into other empty cells in those 3 pre-formatted columns, my new entries were displayed as "12,359." in each case.

So applying the format to an already entered number gives a final "." - I don't know whether the rounding up is acceptable or not. But I imagine the OP wants to enter his number into cells that already have his format applied.

Curiously, when I selected my 3 columns and attempted to return to 'normality' by formatting the cells to Numbers > General, nothing happened. I had to change to some other format than Number (eg date) and then back to numbers-general to get a result.

When Numbers-General was eventually restored, the "124."  entries were returned to their original states of "123.59" but those entries applied to the pre-formatted columns and which then displayed as "12,359." became "12359" under the restored numbers-general regime.

Philip

When I saw the original message my though was that the
person made a typo and had actually used #,##0","
instead of #,##0"."

But waited for someone to come up with another
reason?? Would just be one key off.