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?
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
decimal_aligned.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
