Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |