Exceljet

Quick, clean, and to the point

Apply number format

Windows shortcut 
CtrlShift!
Mac shortcut 
!

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

What can I say. It has worked brilliantly. Thank you so much for your help. - Tracey
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course