Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

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 <joelz@pobox.com> wrote:

> 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 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]

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy