Thread: Truncating numbers to show last three digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
  
Posts: 460
Default Truncating numbers to show last three digits
I need to figure out how to have the numbers truncated as follows:

$25.00 = $5.00
$22.00 = $2.00
$13.50 = $3.50
$10.00 = $0.00
--
Doug
Reply With QuoteReply With Quote