View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to divide a number into various denominators

There's probably an easier way but try this with your number in A1:-

=INT(A1/1000)&" (Thousands) "&INT(RIGHT(A1,3)/100)& " (Hundreds)
"&INT(RIGHT(A1,2)/10)& " (Tens) "&INT(RIGHT(A1,1))& " (Ones)"

I haven't allow for decimals portions.

Mike

"maa" wrote:

How to divide a number into various denominators eg thousands, hundreds,
tens, fives & ones for example 5527 can be divided into 5 (thousand), 5
(hundreds), 2(tens) & 7 (ones).