TransWikia.com

How to read currency values in Numbers?

Ask Different Asked by Berry Blue on October 30, 2021

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?

One Answer

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 "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.

enter image description here

enter image description here

Answered by Natsfan on October 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP