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 <jo...@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+unsubscr...@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
