View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default simple currency addition in cell without having to enter decimal

I want to add dollar amounts in an individual cell with a fixed decimal
point. In other words, click on a single cell, press =, then enter multiple
numbers (preceeded or followed by the + or - sign) without having to enter
decimal for each amount entered.

I have worn myself out trying to format a cell to perform this way but
haven't conquered it yet. Even though it works fine when entering a single
number in a cell, it doesn't work when entering multiple numbers this way in
a single cell. As soon as I press = in the cell, all numbers display without
a fixed decimal point. I have to enter it manually and do not want to have
to do so.

Thanks in Advance,
John Couch