Thread: how to divide the number in one cell into multiple cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default how to divide the number in one cell into multiple cells
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


Reply With QuoteReply With Quote