Conditional formatting, as the name suggests ... We have previously covered how to create a dropdown list in Microsoft Excel and Google Sheets. In the following sections, we will see how to ...

When I thought about the reasons why typing currencies manually should be avoided, the list ended up being ... so using Excel's built-in number format converter is the way forward.