Thread: Significant digits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tiah
 
Posts: n/a
Default Significant digits
Hello !

formula is :

=VALUE(RIGHT(A1,2))

RIGHT will give you last two digits

VALUE will convert the string into numeric

tiah.

Reply With QuoteReply With Quote