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
To ensure alignment use a mono space font such as Courier New. See figure 1.

- Download the file: xlf-text-decimal-alignment [43 KB]
- Development platform: Excel 2016 ProPlus 64 bit.
- Published: 21 August 2018
- Revised: Friday 24th of February 2023 - 02:39 PM, Pacific Time (PT)