View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claudia Claudia is offline
external usenet poster
 
Posts: 32
Default Sum of a number's digits

I need to insert check figures on my spreadsheet that equal the sum of a
number's digits. If cell A1 = 12,345.67, is there a formula that in cell A2
would add the digits 1+2+3+4+5+6+7 to equal 28?

Thanks for your help.
Claudia