Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i multiply two columns the result is in decimal. when i decrease decimal the
value become non decimal (means last digit is up one number). now i want to copy this displayed value in another cell without decimal, how i could do this? e.g. 23 x 10.5 =230.5 after round-up = 231 (this is displayed value). Now I want to copy '231' in another cell, without decimal, it must show '231' as real value. Please help me in this matter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use displayed value, not stored value? | Excel Worksheet Functions | |||
How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Copy just displayed columuns | Excel Discussion (Misc queries) |