Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel, how do you get it to not automatically round my dollars.
In Excel, how do you get it to not automatically round my dollars up or down.
Ex: I am summing a group of numbers and the total equals $598.6780. I want to show only 2 decimal places but do NOT want Excel to round the amount up. I want the answer to show me $598.67 not $598.68. |
#2
|
|||
|
|||
One way
=ROUNDDOWN(A1,2) Think you'll need the analysis toolpak add installed -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Cylie G." <Cylie wrote in message ... In Excel, how do you get it to not automatically round my dollars up or down. Ex: I am summing a group of numbers and the total equals $598.6780. I want to show only 2 decimal places but do NOT want Excel to round the amount up. I want the answer to show me $598.67 not $598.68. |
#3
|
|||
|
|||
=TRUNC(A1,2) might be what you're looking for
"Cylie G." wrote: In Excel, how do you get it to not automatically round my dollars up or down. Ex: I am summing a group of numbers and the total equals $598.6780. I want to show only 2 decimal places but do NOT want Excel to round the amount up. I want the answer to show me $598.67 not $598.68. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel automatically opens files | Excel Discussion (Misc queries) | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions |