Rounding and dropping digits
Marissa Sorry. Initially I read this as 567.549 instead of comma....
Gord has answered this..Cheers
If this post helps click Yes
---------------
Jacob Skaria
"Marissa" wrote:
Thank you but it did not work. The result was the number in A1.
"Jacob Skaria" wrote:
A1 = 567,549
=ROUND(A1,0)
If this post helps click Yes
---------------
Jacob Skaria
"Marissa" wrote:
Hello,
Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.
|