| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do your round down an entire column?
I am trying to round down an entire column of currency with different
amounts. I can do it with one cell at a time but I need to do the entire column. For example I want to take $15.75 to $15.00 and $14.34 to $14.00 and so on all the way down the column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Making a spreadsheet for orders | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| a fomula for an entire column | Excel Discussion (Misc queries) | |||
Threaded Mode
