Find last three digits after . ( including zero)

		Microsoft Office Forums > Microsoft Excel > Excel
Find last three digits after . ( including zero)

02-06-2018, 01:11 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit Find last three digits after . ( including zero)

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

Code:

 
=A1-TRUNC(A1)

Problem resolved.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having number's digits together	mohsen.amiri	Word	0	06-23-2017 01:20 AM
Digits are not found in my document!	reza8615953	Word	3	04-18-2017 10:48 AM
Macro for find/replace (including headers and footers) for multiple documents	jpb103	Word VBA	2	05-16-2014 04:59 AM
Multi-Doc Find/Replace, Including Headers/Footers & Textboxes	konopca	Word VBA	3	05-05-2014 03:18 PM
Problems merging in last 4 digits of an account higher than 16 digits	Glynda	Mail Merge	1	04-08-2011 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 AM.