Thread: Change last number to 9
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Change last number to 9
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!

=ROUNDUP(A1+0.01,1)-0.01
Reply With QuoteReply With Quote