Comments on: Applied Gestalt Laws: Table Alignment ../../../../2008/05/applied-gestalt-laws-table-alignment/ XLCubed Blog Thu, 10 Jan 2019 09:17:20 +0000 hourly 1 https://wordpress.org/?v=5.3.21 By: xlcubedblog ../../../../2008/05/applied-gestalt-laws-table-alignment/#comment-14 Wed, 03 Dec 2014 07:52:12 +0000 http://blog.xlcubed.com/applied-gestalt-laws-table-alignment/#comment-14 Thanks Paul, we’ve updated that link!

]]> By: Paul ../../../../2008/05/applied-gestalt-laws-table-alignment/#comment-13 Tue, 02 Dec 2014 22:10:23 +0000 http://blog.xlcubed.com/applied-gestalt-laws-table-alignment/#comment-13 Broken link to previous post?

]]> By: Elektrische Zahnbuerste ../../../../2008/05/applied-gestalt-laws-table-alignment/#comment-12 Wed, 23 Nov 2011 13:32:14 +0000 http://blog.xlcubed.com/applied-gestalt-laws-table-alignment/#comment-12 … [Trackback]…

[…] Informations on that Topic: blog.xlcubed.com/2008/05/applied-gestalt-laws-table-alignment/ […]…

]]> By: jeffrey weir ../../../../2008/05/applied-gestalt-laws-table-alignment/#comment-11 Thu, 07 May 2009 09:23:17 +0000 http://blog.xlcubed.com/applied-gestalt-laws-table-alignment/#comment-11 Question is, how do you align numbers at the decimal point in Excel?

I found a workaround at http://excel.tips.net/Pages/T002765_Decimal_Tab_Alignment.html and another at http://www.cof.orst.edu/net/software/excel/tips/

The 2nd site says Decimal Alignment (With Varying Significant Digits)
A decimal tab in Word will let you align a column of numbers at the decimal point even when there are varying numbers of digits to the right and left of the decimal point. To do the same in Excel, Format | Cells using a Custom format of ????.??? with enough question marks on either side of the decimal to accommodate the most digits you have in any of your numbers.

]]>