Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Decimal points not needed
I use functions to change price lists, but I don't need the currency shown
with decimal points, even though I use the format cell facility and request settings with whole numbers only at times the answer is shown to 2 decimal places and cannot be changed using the format cell. Why is this? For example I have a trade price of 1283 which I multiply by 2.4 to give 3079 in an adjacent cell when I view this in the formula bar it shows 3079.2 which I don't want as this data is uploaded to a database and needs to be whole numbers. |
#2
|
|||
|
|||
Display format has nothing to do with how the value's stored/calculated.
If you want the value always to have the displayed precision, check the Precision as displayed checkbox in Tools/Options/Calculation. This is a global change for the workbook, however. Otherwise, use ROUND() (or possibly INT()) to give you whole numbers: =ROUND(1283*2.4,0) In article , "Paul K." wrote: I use functions to change price lists, but I don't need the currency shown with decimal points, even though I use the format cell facility and request settings with whole numbers only at times the answer is shown to 2 decimal places and cannot be changed using the format cell. Why is this? For example I have a trade price of 1283 which I multiply by 2.4 to give 3079 in an adjacent cell when I view this in the formula bar it shows 3079.2 which I don't want as this data is uploaded to a database and needs to be whole numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
Distance between GPS points (Decimal degrees) | Excel Worksheet Functions | |||
Distance between two GPS points (Decimal degrees) | Excel Worksheet Functions | |||
division and decimal points | Excel Worksheet Functions |