How to read currency values in Numbers? I have currency values in the following format in a CSV file.
$171.5M
$2.74B

How do I have Numbers recognize these as proper currency values for sorting?
You can't use the letters  B or M in the cell. you have to use all the digits.  Open numbers and on the right side of the window, on the top right corner be sure to click on Format. You should have 4 tabs underneath Format that read &quot;Table, Cell, Text, Arrange. Click on the Cell tab and a new panel appears with a pulldown menu Data Format. One of the options under this menu is Currency, select that and you should be good to go.  My setting is Automatic and it usually recognizes the $ sign as currency.  See image below.