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

10y 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


How do you Convert decimal 65535 to its hexadecimal?

In any numbering system each numeral is a power of the base number. For example, in base-10 (Decimal), the first decimal place on the right is that number times 10 to the 0th power. (Just talking about Integers right now.) The next digit is that number times ten to the 1st power, and so on. For example: The decimal number 635 is represented as (6*10^2)+(3*10+1)+(5*10^0) So in Base 16, each number place would be that number times 16 to the nth power. To make 16 numbers, we have to add some numerals to go beyond 9... The common convention is to use Letters. So in hexadecimal, you could 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F. The decimal values of a hexadecimal number starting from the left at the 5th digit would be: 65536 4096 256 16 1 So to come up with a value equal to decimal 65535, we would have to find numbers that add up to that value. Obviously the first digit won't work. It's already over 65535 just for one. Let's look at the next digit with value 4096. If we take that times the maximum value of the place (15 in decimal, or F in hex), we can get up to 61440. So we'll put F in that place. Our number is currently Fxxx. The next digit has a value of 256 times the number in that place. So we check the maximum value of 15*256 = 3840. Add that to the 61440 from the first digit, and we get a total of 65280. Still below 65535 so we'll drop another F value there as well. Our number is now FFxx. Next to last digit! It has a place value of 16. The maximum value then is 15*16, or 240. We add that to the 65280 from the last calculation and get 65520. Pretty close, but not quite up to 65535 yet. Our number is now FFFx. Final digit! It has a value of 1, so maximum value for this first digit is 1*15, or 15. Add 15 to the prior calculation of 65520 and we get... 65535! Ta da! So the final calculation is that 0xFFFF = 65,535 in decimal. (The 0x is an indicator that the number following is in Hexadecimal.) Hope that helps!