Thread: Force display to round down
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Force display to round down
On Wed, 1 Apr 2009 10:53:03 -0700, Jacob Skaria
wrote:

Use the function RoundDown

=ROUNDDOWN(A1,0)
--
If this post helps click Yes
---------------
Jacob Skaria

Of course, that would change the value in the cell.
--ron
Reply With QuoteReply With Quote