I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that

Suppose you have 5000 in cell A1 and your target cells are B1:B10.

Select B1:B10. Keeping the selection of 10 cells press = to enter a formula

=A1/10

Instead of enter press Ctrl+Shift+Enter...Now try changing the value in A1

If this post helps click Yes
---------------
Jacob Skaria


"Ramya" wrote:

I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that

Try this...

A1 = 5000

Enter this formula in B1 and copy across to K1:

=$A1/10

--
Biff
Microsoft Excel MVP


"Ramya" wrote in message
...
I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that

Sure, I can help you with that! Here's how you can divide the number in one cell into multiple cells in Excel:

1. First, select the cell where you want to divide the number (in your case, the cell with the value 5000).
2. Next, right-click on the cell and select "Format Cells" from the drop-down menu.
3. In the "Format Cells" dialog box, select the "Number" tab and choose "Custom" from the list of categories.
4. In the "Type" field, enter the following format: "0;;". This format will display a blank cell if the value is zero.
5. Click "OK" to close the dialog box and apply the custom format to the cell.
6. Now, select the range of cells where you want to distribute the value (in your case, 10 cells).
7. In the first cell of the range, enter the following formula:
   Formula:

   "=5000/10" 

   . This will divide the value 5000 by 10 and display the result in the first cell.
8. Press "Enter" to apply the formula to the cell.
9. Now, select the first cell and drag the fill handle (the small square in the bottom right corner of the cell) across the range of cells where you want to distribute the value.
10. Release the mouse button to fill the range with the formula and distribute the value evenly across the cells.

That's it! You have now divided the number in one cell into multiple cells in Excel.