Thread: Decimal Places
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Decimal Places
Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2))

Two parentheses more than needed...

=A1+A2/10^LEN(A2)

Rick
Reply With QuoteReply With Quote