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?
MacOS – How to read currency values in Numbers
macosnumbers
Related Solutions
If I'm not mistaken you could do that more or less easily:
Say for example column comedy.
The total is 534 (sum).
- 132 (1st row) is the 24.71% (132 x 100 / 534).
- 3 (2nd Row) is the 0.56%…
- 1 is the 0.18%
- 398 is the 74.53%.
The sum of 24.71+0.56+0.18+74.53 == 100% (minus rounding, add more decimals for more precision).
So if you add a final ROW with the SUM (below technology for example) you can cause each cell to perform a Cell * 100 / TOTAL_OF_COLUMN and get your %.
What am I missing?
I tested this in Numbers '09 2.3 (554), and it worked for me without doing anything particularly special: see below. Have I understood correctly?
Related Question
- MacOS – How to keep Numbers from mangling numbers when importing a CSV
- Mac – Exporting CSV with Numbers with different languages
- Xls to csv – Numbers creates multiple csv files for some reason
- How to prevent Numbers from changing currency automatically
- (Numbers) COUNTIF values from one column match another column
- MacOS – Get values from Numbers.app into AppleScript’s variables
- How to Sum text values like numbers in Numbers
- Capture month end values in Apple Numbers
Best 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.