View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
osbornauto osbornauto is offline
external usenet poster
 
Posts: 2
Default Format financial results to end in specific numbers

I have a one page spreadsheet with some financial calculations filling in a
few cells as results. I'd like to have each of the cells end in a specific
cents. So, in the results cell, if the calculation was to give the results
of $10.56, $11.74 & $13.23 - it would actually show up as $10.55, $11.55 &
$13.55 if I wanted the results to end in 55 cents.

Any suggestions on how to have all my results end in a specific result like
that?