answersLogoWhite

0


Best Answer

If you mean 4 decimal places, then in Excel,

Highlight the relevant cells.

The select Format, Cells

Select the Numbers tab.

Select Number and then, on the right hand side, select the number 4 in Decimal places.

And then OK back.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you add 4 decimal in the cell value?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

What is a double in visual basic?

A double essentially is an int but with a decimal. For example, 4.5 is a double. But the int value of that would be 4


What decimal number corresponds to the binary number 00000111?

When writing binary numbers . . . The first place has the value of 1. The second place has the value of 2. The third place has the value of 4. The fourth place has the value of 8. '1 0 1 1 ' has (fourth place) + (second place) + (first place) = 8 + 2 + 1 = decimal 11 .


Number 15 in binary form?

Rather than tell you what the answer is, I think it better that you learn how to do this your self. By asking the question you must realize that each binary digit can have a value of one or zero. Just like with decimal numbers, the digit of lest value is on the right and has a decimal value of one. The digit immediately to its left has a value that is twice that of it neighbor to the right and also half the value of its neighbor to the left.Here is the decimal values of 8 binary digits.[128][64][32][16][8][4][2][1] decimal value( 8)( 7)( 6)( 5)(4)(3)(2)(1) digit placeLets convert 25 decimal into binary.The largest decimal value that can be subtracted is 16 with 3 digits to the left, write down 3 zeros as place holders for the 3 left digits. Follow by a one.000125 - 16 = 9The next binary digit to the right has a decimal value of 8 and can be subtracted from 9 so we write down another 1.000119 - 8 = 1Now for each binary digit that has a decimal value greater than the remainder write a zero.0001100Now there is just the 1 left to deal with. Any time there is only 1 left you can just write down a 1.00011001So with that short intro to converting decimal into binary you should be dangerous enough to do your own decimal to binary conversions. (If still in doubt try, Google for an explanation that makes more sense to you).


The binary value of -3 is?

1101 in 4 bits,11111101 in 8 bits,and so on: add leading 1's as necessary


Decimal no to binary no?

Binary numbers start with a column with the value of 1 on the right side. The next column, to the left, has double the value (which is 2), the next left doubles again (which is 4), then 8, 16, 32, 64, 128 etc. The inclusion of a number 1 in a column means that the number should be included in the total. The inclusion of a zero in a column means that the number should not be counted. Using just this combination of 1s and 0s any number can be represented. For example... 1 = 1 2 = 10 3 = 11 4 = 100 10 = 1010 15 = 1111 65 = 1000001 To convert the numbers from binary to decimal you can simply use a calculator and starting at the right side of the binary number if the first digit is 1 then add 1 to your calculator. If it is zero don't add anything, move left to the next column, if there is a 1 in this column add 2 to your total on your calculator, if it is a zero don't add anything, continue doing this, doubling the value for each column and adding the number if there is a 1 and ignoring it if there is a zero. For example.... The binary number 1100, starting at the right has 0 in the 1 column, 0 in the 2 column, 1 in the 4 column and 1 in the 8 column, so you would ignore 1 and 2 and simply add 4 + 8, giving your a value of 12, which is correct.