Thread: Zero Decimal Places
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Blue Blue is offline
external usenet poster
  
Posts: 23
Default Zero Decimal Places
John,

Cells(ActiveCell.Row, ActiveCell.column + 1).Value = Format(sqmrc1,"0")

Did the trick, Thanks

Blue


Reply With QuoteReply With Quote