Microsoft Office Forums - View Single Post - [Solved] Find last three digits after . ( including zero)

Thread: [Solved] Find last three digits after . ( including zero)

View Single Post

Old

02-06-2018, 01:11 AM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2003

LearnerExcel uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

Code:

 
=A1-TRUNC(A1)

Problem resolved.

Reply With Quote