View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default how do i sum dollars & cents in different columns

Now you know how to do it, can one ask why two columns? Why not, for
example, 12.25 in one cell for $12.25?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
In my account sheet I need to have dollars in the first column and cents
in
the second. For my total row I would like to be able to have everything
sum
(dollars and cents) and then be displayed as it is above (dollars in the
first column and cents in the second) How in the world is this done???
email
me at