Thread: Rounding and dropping digits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Rounding and dropping digits
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.
Reply With QuoteReply With Quote