Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What are you trying to do? If I understand what you are writing below, you
want a number, for example, 721, to be entered as 721, treated in all calculations as 721, but what is displayed is only 700? Wouldn't this cause some concern if, for example, you knew 2 numbers were supposed to be added up, but it looked very wrong. i.e.: 700 (721) + 600 (647) = 1400 (1368) If not, please explain more. -- John C "Tarfun" wrote: What is the custom format to display numbers to the nearest 100 or nearest 10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that way will retain its unrounded value in memory for all computations performed using it. (Not so using the "Round" Function.) -- Leo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formatting | New Users to Excel | |||
custom formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Custom formatting | Excel Discussion (Misc queries) | |||
custom formatting | Setting up and Configuration of Excel |