Thread: Change last number to 9
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Change last number to 9
Try

=ROUNDUP(A1,0)-0.01

Mike

"Laura Lee Day" wrote:

I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so
that the last number is a 9....please help!
Reply With QuoteReply With Quote