sorting decimals, then special format

**ngpm515** · 12-07-2009, 05:20 PM

Hi, in column A I have something like this:
0+25.000
0+50.000
0+51.000
0+75.000
0+75.010
1+25.000
1+50.000
1+75.000
etc.....

I have 2 questions:
1) How do I sort out the ones that are not round numbers? In this example 0+51.000 and 0+75.010.

2) How do I copy only the "+ part" without decimals, i.e: +25, +50, +75 to another column keeping the same sequence for the whole column?
Thanks in advance.

**Special-K** · 12-07-2009, 05:41 PM

1) Why is 51.000 not a round number?

2) =MID(A1,2,3) if all your decimal values are 2 digits long

=MID(A1,2,FIND(".",A1,2)-2) if they vary

**ngpm515** · 12-07-2009, 06:42 PM

In my case, I use the 25' increment starting at 0. Therefore, anything that is not 0,25,50, or 75 will not be considered round and needs to be eliminated.
How do I go about sorting those numbers out in my case?

Anyway, my question 2 got resolved. Thank you so much.

**DonkeyOte** · 12-08-2009, 04:13 AM

Not sure I follow but if the values in A are strings then

B1: =MOD(REPLACE(A1,1,FIND("+",A1),""),25)=0
copied down

where above returns FALSE then "not round" per your spec.