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: Monday 20th of August 2018 - 03:53 PM, Pacific Time (PT)