Question

Function Library A1+B1)/2 fx E1 A C D G #VALUE ! 1 19+89.67 20+89.67 2 3

I need the addition sign in my answer. It is not used as a math function, but more like a decimal holder. Example if I have the two values 20+50 and 19+50 I need it to return 20+00. thank you.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Go to File Menu

2. Go to options

3. In the dialog box, click on Advanced Tab

4. At the bottom of the dialog box, you'll find "Decimal Operator" and "Thousands Operator" options.

5. In the decimal operator text box, change '.' to '+'

6. Press OK

Now you can use '+' operator as the decimal placeholder in your excel sheet.

These steps are for Excel 2016, might be a little different for other versions.

Add a comment
Know the answer?
Add Answer to:
I need the addition sign in my answer. It is not used as a math function,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • For this question, I am wondering about why my math isn't right. I get the correct number but in ...

    For this question, I am wondering about why my math isn't right. I get the correct number but in the wrong units. I got 7.848*10^-19, but I would like a explanation about why my math is wrong. Thank you 10 cm2s ls-(100fmŕ)(1.6x10-19 C)(1.5x 1010 /crm ) lSm)(10/cm) 18 cm2s (10/m)(10"/cm) 3600 C 7848 x 10-16_ = 7848 × 10-16 (C)( 10-4cm cm 10 "(C)( m) cm 1,-0.7848x1016 A Therefore, the saturation current value is 1. 0.7848x10-16 A 10 cm2s ls-(100fmŕ)(1.6x10-19...

  • Need help with output form -I need my variables and strings in my print function to...

    Need help with output form -I need my variables and strings in my print function to be separated by underscores _. Thanks. m, d, y=eval(input("Enter the date like so m, d, y: ")) files=eval(input("How many files?: ")) fName=(input("Enter your family name: ")) FROM THIS: print(fName,m,d,y,".txt") FORM OUTPUT NEEDS TO BE IN: name_month_day_year.txt

  • I haven't code in awhile and would like some help getting back on my feet. Need to code this in C++. Thank you! In...

    I haven't code in awhile and would like some help getting back on my feet. Need to code this in C++. Thank you! In this homework, you will implement a simple version of the game Battleship, in which the player tries to destroy ships hidden on a map using a system of coordinates. In this program, the map will be represented by a 4x4 matrix of integers. A 1 in the matrix represents the presence of a ship. There are...

  • Hello everyone! I need help on these few questions from my elementary calculus class, I am...

    Hello everyone! I need help on these few questions from my elementary calculus class, I am very confused, It is question 1a,b,c,d,e,f,g I need help on. Thank you so much :) - Anna 1. Find the derivative of the function. 5x7 - 773 + + 4x + 10 (a) f(x) = (b) f(x) = (x+3)(x2 + 2x - 4) (c) g(x) = (3x2 + 4x)" (d) y=2tV2 + 4 2002 - 2 (e) h(x) 1-23 (f) y = (3e' -...

  • e Incorrect Your answer is wrong. In addition to checking your math, check that you used...

    e Incorrect Your answer is wrong. In addition to checking your math, check that you used the right data and DID NOT round any intermediate calculations. Nickel carbonyl decomposes to form nickel and carbon monoxide, like this: Ni(CO)4(9) Ni(s)+4 CO(9) At a certain temperature, a chemist finds that a 7.8 L reaction vessel containing a mixture of nickel carbonyl, nickel, and carbon monoxide at equilibrium has the following composition: compound Ni(CO)4 Ni amount 0.288 g 89.3 g CO 1.07 g...

  • I have the answer I just need help explaining. I got the reaction I wanted but...

    I have the answer I just need help explaining. I got the reaction I wanted but my O2’s did not cancel like they should. 18. Calculate AHnn for the following reaction: given the following: 4 B(s)+3 02(g) 2 B,03(s) AH- -2543.8 kJ AH -241.8k AH -2032.9 kJ H2g) + 1/2 O2(g) H2(g) B2Ho(g) +3 O2(g) B20,(s) +3 H20(g) a. -752.7 k b. -4030.2 kJ c. -4818.5 kJ d. +35.6 kJ e. +1280.2 kJ 19. What is STP (standard temperature and...

  • I need help with 19 and 20. I tried my best on 19 but I don't...

    I need help with 19 and 20. I tried my best on 19 but I don't know if the answer I circled is correct. Thank you. Use the graph below to answer the next two questions MC ATC $Price $12 Z MR SIO $9.75 opinion planosno is asheviote/i / l Avc AZ MR s ni b u dardi songsdl. alle / svo / hos olla lubivibilons Sans que lo 20onnalisa moss andia-aong nominovano sodninaluubi ne b allo 50 60 ob...

  • i paid my last dollars for help and you people give me the wrong answer or...

    i paid my last dollars for help and you people give me the wrong answer or dont even answer my question!!! im failing my class and no one helps me! im sick and tired! i have to post the same question multiple times just so someone can see it. uncc.instructure.com Partial Question 14 4/16 pts Fifty male subjects drank a measured amount z(in ounces) of a medication and the concentration y (in percent) in their blood of the active ingredient...

  • Must be written in basic C language. I keep getting stuck with my code. Step 1:...

    Must be written in basic C language. I keep getting stuck with my code. Step 1: You are to write an algorithm to compute e1 using the Taylor Series Expansion n! o Use the highest precision possible Step 2: Calculate the error between your algorithm and the value computed using the function exp(x) found in the <math.h> library. .Step 3: Calculate how many digits of precision is your algorithm.

  • I need help making my array into a function that can called by the main function...

    I need help making my array into a function that can called by the main function using my program. This is C programming int prime (int x) { int i; i = 2; while (i < x) { if (x % i == 0) return 0; i++; } return 1; } int main (void){ int n; scanf ("%d", &n); if (n < 1) { printf ("Error: at least one data value must be provided.\n"); return 1; } int a[n]; int...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT