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.

I also wanted to tell you in researching this formula problem, I combed through about 50 videos and websites. Yours was the most professional, easy to understand, and welcoming to a student who wishes to become more knowledgeable with Excel. -Devorah
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course