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

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 these formats display the cell
contents with a trailing decimal point, but with this
formatting, inputting 123.45 results in cell content 12345.


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

-- 
Joel Roth

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