Excel custom format What does -2 mean

0 votes
I've seen [$€-2] here in Europe, which is supposed to be the Euro symbol. How is the surrounding information parsed?

Recently, I received a spreadsheet from someone in Argentina that contained a number formatted as money and displayed as [$$-240a]. The 240a is in Spanish, okay. I understand that this is probably a location as well because of Columbia.

I'm confused about how these are parsed.
Oct 30 in Others by Kithuzzz
• 20,660 points
36 views

1 answer to this question.

0 votes

The 2 in [$€-2] is a "Numeral shape code" and refers to "Arabic Indic" number representation. The € leads to currency format. Read more about it here.

answered Oct 30 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

can somebody explain me what does "passing by value" and "Passing by reference" mean in C#?

To answer your question, “passing by value” ...READ MORE

answered Feb 10 in Others by Rahul
• 9,680 points
174 views
0 votes
1 answer

What does enctype='multipart/form-data' mean?

When any POST request is made, then ...READ MORE

answered Feb 10 in Others by Rahul
• 9,680 points
433 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

What does "collect2: error: ld returned 1 exit status" mean?

 The ld returned 1 exit status error ...READ MORE

answered Feb 22 in Others by Aditya
• 7,660 points
24,949 views
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
123 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
48 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
53 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
58 views
0 votes
1 answer

What does the " @ " symbol mean in Excel formula (outside a table)

Excel has recently introduced a huge feature ...READ MORE

answered Nov 26 in Others by narikkadan
• 37,660 points
18 views
0 votes
1 answer

What are the RGB and HEX codes of the 3 color conditional format in Excel?

In Excel 2016 at least the colors ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
391 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP