On 11 May 2021 at 13:24, Philip Jackson wrote:
Subject:Re: [libreoffice-users] Calc: Formatting cell
with decimal point but
no decimal digits
To: users@global.libreoffice.org
From: Philip Jackson
Date sent: Tue, 11 May
On 11/05/2021 03:22, Joel Roth wrote:
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.;-)
On my version (6.1.5) both of these formats display the cell
On Mon, May 10, 2021 at 05:18:46PM -0700, Chuck Spalding wrote:
> 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. ;-)
On my version (6.1.5) both of
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. ;-)
Chuck
On Mon, May 10, 2021 at 12:37 PM Joel Roth wrote:
> On Mon, May 10, 2021 at 12:05:04AM -0600,
On Mon, May 10, 2021 at 12:05:04AM -0600, Joe Conner wrote:
> In calc, you could format the cell as currency.
Thanks, I tried this, but wasn't able to display a terminal
decimal point.
> On 5/9/21 3:36 PM, Joel Roth wrote:
> > Hi list,
> >
> > I'd like to input 123.45 and format it with a
Type
locale
in a terminal. What locale are you?
I am 'en_US'.
This works for me:
Type 123.45 in a cell
Highlight the cell
Format - Cells - 'Numbers' tab -
Make 'Decimal places:' under Options zero (0).
Mike
On 5/10/21 1:04 AM, users+h...@global.libreoffice.org wrote:
Hi list,
I'd like
In calc, you could format the cell as currency.
On 5/9/21 3:36 PM, Joel Roth wrote:
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
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.
--
Joel
