i have large excel file contains many way-points in latitude , longitude in degree , minutes. problem numbers can't rounded , must stay same, last 2 numbers need removed (in cases)
i wondering if there formula allow 3 characters past decimal. how numbers look.
26° 17.82964
however
26° 9.82
i know can format cell number , set decimal place 3, when copy , paste doesn't stay same.
this formula truncate (it not round) numbers , give if less:
=mid(a1,1,find(".",a1)+3) 
this formula round, fill out numbers 3 decimal places (i aware op did not want rounding, others may want it.):
=left(a1,find(" ",a1))&text(round(--mid(a1,find(" ",a1),len(a1)),3),"0.000") 
Comments
Post a Comment