dshrenik
asked on
Round a number
Please tell me how I can display the rounded version of a number (without using a function).
THe number is the cell must display the rounded version, but the actual value must still be the non-rounded version.
THe number is the cell must display the rounded version, but the actual value must still be the non-rounded version.
Just set the cell format to Number with 0 Decimal places.
ASKER
If possible, can you give me the procedure to do the same. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thats not rounding the number. IT is just trimming it right?
No, it's rounding the number for viewing but the original number is kept intact. try it please.
ASKER
Sorry about that!