Thread: Want to divide a number into groups of thousands
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ooley Ooley is offline
external usenet poster
  
Posts: 1
Default Want to divide a number into groups of thousands
I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:

1000
1000
1000
450

I want this to repeat in as many cells as needed to get down to 0.

Any suggestions?
Reply With QuoteReply With Quote