Exceljet

Quick, clean, and to the point

Apply currency format

Windows shortcut 
CtrlShift$
Mac shortcut 
$

Apply the Currency format with two decimal places.

Related videos

Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and even random text values. This is a great way to create dummy data to test formulas and worksheets.