Thread: truncate
View Single Post
  #1   Report Post  
tamar
 
Posts: n/a
Default truncate

How do I truncate my numbers so that $54.2223456 is changed to $54.22? I
know how to round, but I want the actual base number to be truncated, not
simply the number that appears in the cell. All my numbers are currency, so
want two numbers after the decimal. I tried truncating to a certain number
of total characters, but that doesn't help since $54.22 has fewer characters
than $13294.32, but both are correct.
Thanks!