Thread: split dollars and cents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yodochi yodochi is offline
external usenet poster
  
Posts: 7
Default split dollars and cents
hi, how do i split dollars and cent in 2 colums and at the end sum it,
for example: A1 Dollar, B1 cents, A2 dollar, B2 cents and in A3 and B3
the sum result of A1,A2 and B1 B2.
thanks for help
Reply With QuoteReply With Quote