How to filter numbers with specific format

[pmahbub]

Hi,
Please consider the following numbers which are just used as an example from my LED spectra:
1399.9879854
1399.9989564
1400.0000125
1400.0008596
1401.0113564
1401.1136548
1401.3215648

From these rows of numbers, I would only like to select the numbers that contain 0000 or 000 after the decimal point. Any advice to do it in excel?

Kind Regards
Parvez

[FlameRetired]

Parvez welcome to the forum.

The first idea that comes to me is to create a helper column with this formula.

=TEXT(MOD(G2,1),".0000000")

Then apply Filters to the helper column > Contains > contains .0000 then click Or contains .000

	G	H
1	Spectra
4	1400.0000125	.0000125
5	1400.0008596	.0008596
9
10
11
12
13
14
15

[pmahbub]

Thanks very much.
Regards
Parvez

[MarvinP]

Hi pmahbub and welcome to the forum,

I think you can do this using numbers, without needing to go to text with a formula like:

=MOD(A2,1)<0.001

With your numbers in A2 and down the A column.

[pmahbub]

thanks very much.

[FlameRetired]

You're welcome. Thanks for the feedback.