xlf QandA series

Decimal alignment using question mark place holders - format "???.???"


QUESTION

I CANNOT GET THE TEXT FUNCTION DECIMAL ALIGNMENT TO ALIGN THE DECIMALS


Answer icon Answer


To ensure alignment use a mono space font such as Courier New. See figure 1.



xlf-text-decimal-align
Fig 1: TEXT "???.???" - with monospace font Courier New