Issue with Apple Numbers Functions. Text and Actual

[danny klim]

I am trying to get the sum of added numbers from a CVC file i downloaded of amazon purchases. The sum function is not working. Could you please help me figure out why?
It works fine when I enter the numbers, but not for numbers that Amazon added. I thought that I needed to delete the $ on all of the the numbers amazon gave me (it came with a dollar sign in the text I think, which I thought was throwing off the calculations), but that did not fix it . I used almost the same numbers right next to the numbers amazon gave me in the next cells over and the sum works fine there. The ONLY difference is that the bottom left corner of numbers says “TEXT” for the amazon numbers, and “ACTUAL” for the numbers I added, so im guessing this must be the source of the problem, but I dont know how to make it work right for the numbers that amazon gave me. You can see what im talking about better in these screen shots below.

Could you please help?

Thanks, Dan
Formula that isn’t working:
https://www.dropbox.com/s/m9mf2239gg9nbzf/Screenshot 2018-03-01 17.30.38.png?dl=0

Selection of cell in formula that is not working:

https://www.dropbox.com/s/d5pww7ov5g6l4ik/Screenshot 2018-03-01 17.34.44.png?dl=0

Formula that is working:

https://www.dropbox.com/s/vt97277bvgqjoo7/Screenshot 2018-03-01 17.34.10.png?dl=0


Selection of cell in formula that is working:
https://www.dropbox.com/s/on18cqc51utsu53/Screenshot 2018-03-01 17.35.18.png?dl=0

 

[mailbuoy]

I am trying to get the sum of added numbers from a CVC file i downloaded of amazon purchases. The sum function is not working. Could you please help me figure out why?
It works fine when I enter the numbers, but not for numbers that Amazon added. I thought that I needed to delete the $ on all of the the numbers amazon gave me (it came with a dollar sign in the text I think, which I thought was throwing off the calculations), but that did not fix it . I used almost the same numbers right next to the numbers amazon gave me in the next cells over and the sum works fine there. The ONLY difference is that the bottom left corner of numbers says “TEXT” for the amazon numbers, and “ACTUAL” for the numbers I added, so im guessing this must be the source of the problem, but I dont know how to make it work right for the numbers that amazon gave me. You can see what im talking about better in these screen shots below.

Could you please help?

Thanks, Dan
Formula that isn’t working:
https://www.dropbox.com/s/m9mf2239gg9nbzf/Screenshot 2018-03-01 17.30.38.png?dl=0

Selection of cell in formula that is not working:

https://www.dropbox.com/s/d5pww7ov5g6l4ik/Screenshot 2018-03-01 17.34.44.png?dl=0

Formula that is working:

https://www.dropbox.com/s/vt97277bvgqjoo7/Screenshot 2018-03-01 17.34.10.png?dl=0


Selection of cell in formula that is working:
https://www.dropbox.com/s/on18cqc51utsu53/Screenshot 2018-03-01 17.35.18.png?dl=0

You may have already diagnosed your problem.

Select the troublesome column in the table. In the Format Inspector, select Cell (you have Table selected in the pics you posted). Then under Data Format, select the type of data you want (Number, Currency, etc.).

Did that do it?