Thread: [Solved] Find last three digits after . ( including zero)
View Single Post
 
Old 02-06-2018, 12:53 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Find last three digits after . ( including zero)
How to get last 3 digits after "." (Decimal) including zero ? The following formula doesn't work?

Code:
 =RIGHT(A1,3)
Example: 88,485.90 ----------- The result is 5.9 (But I need here .90 inculding last ZERO)
88,485.95 ----------- The result is .95 (Here it is okay as it gets last 3 digits after Decimal)

How to modify the formula?
Reply With Quote