They work well for positive numbers but may struggle with negative values, often requiring additional rules or manual adjustments to display them correctly. Using Excel Auto Formatting as you Type ...