Extracting data with certain "0000" characteristics

[panyagak]

Hi.

I wish there was a way to attach a simple .xlsx file here.

Just realised a pattern in my data analysis of (nearly 300 rows) BUT scratching my head how to extract all rows that have this "weird 0000s in the values in the 3 columns C D E.

Column B is Details in case a vba is apt.

My data approximates this:
A B C D E
Date 2.62000 1.62000 0.60000
" 1.35000 0.35000 0.75000
" 1.43627 2.43627 1.46000
" 2.87742 3.87742 1.4354

 

[Special-K99]

That could be formatting to 5 decimal places.
Or could be text instead of numeric values.

 

[SyedUsman]

Use Text To Columns

Select the Column (Single Column) Data > Text To Column > Next > Next > Finish

cheers.

 

[panyagak]

Problem is not Formatting - I did it myself......should actually be longer than that.

How do I extract the first 2 rows in my simple example & then given 300 rows.

Please Note a constant 1.00 difference between Colns C & D.