How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been ... passed arguments—you passed the wrong number. #NUM!: Check for a circular reference ...

This works but it’s not appropriate in all situations, and there is a smarter solution using Excel’s Custom Formats feature. Check the Sample area to make sure the number looks the way you want, and ...