is common to encounter difficulties when we must add a set of values \u200b\u200bprepending a currency symbol.
not have to write symbols ($, U $ S) . Excel automatically adds. If we do, show them as text and not add the quantities.
It is best to type the numbers without any form-even without points separating thousands, which automatically adds also EXCEL format, and once loaded the data. Upload
first numbers plain and add:
To format pesos and two decimal places, go to Format Cells / Currency : 
The thousand separator (.) is item number
And here the quantities in its final form.
To do calculations with EXCEL be separated with coma (not point) the whole of the decimal.
correct: incorrect
345.97: 345.97
