In news:[email protected], Paul Gress <[email protected]> typed: > On 12/22/10 02:13 PM, Paul Cohen wrote: > Is there any way to format data in a column so that the > decimal points are aligned?
Yes, there is. See Help and search for Tabs, then under that, Settings. It tells you there how to set a decimal tab stop. Excerpt: Decimal Aligns the decimal point of a number to the center of the tab stop and text to the left of the tab. The character that is used as a decimal separator depends on the regional setting of your operating system. You gave no details, so I assumed OO.o V3.x on XP to check out the Help and assumed a Writer document since you gave no hint otherwise. So yes, it can do it. Then I played with it, as I've done before, and it works as expected. The advice to simply right-align the numbers doesn't work unless ALL data to format has the same number of digits to the right of the decimal. This Decimal Tab works directly on the decimal and doesn't care how many digits are before/after the decimal. Also please do not post in HTML mode: Use Plain Text instead for all newsgroups unless they specifically say otherwise. There are still a lot of good newsreaders around that will only display garbage if you use the HTML mode. If you don't know how to do that, see your news client's Help for assistance. HTH, Twayne` > > > > > There are two ways. As stated previously, set the number > of decimal places and right align. This would work if a > mono space font is used. > > The second solution is what I've done (in my invoices I > send out). In the attached sample "decimal_aligned.ods", I > enter the dollar value in cell column "A" and the > significant value is displayed in cell column "B" without > the decimal value and the decimal value in displayed in > column "C". This solution doesn't care about what type of > font is used, it can be two different fonts and the decimal > will always line up. > > Paul > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
