View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Excel Formula Help

I need a formula that will truncate the value and provide the dollar amount
as follows:

Entry Calculated Number
$10.00 = $0.00
$22.50 = $2.50
$50.00 = $0.00
$75.00 = $5.00

I basically need to see the value of the last three digits of the amount
posted in the column. The column contains over 5000 entires, which is why I
need a formula.

Thanks
--
Doug